Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

Correctly inserting literals in PL/PgSQL EXECUTE dynamic queries

How to remove conditions from WHERE clause if parameters are NULL

sql postgresql null plpgsql

postgresql function: Final statement returns bigint instead of integer

sql postgresql plpgsql

Psycopg2 callproc and sql parameters

python psycopg2 plpgsql

Unescape a string with escaped newlines and carriage returns

PostgreSQL function with duplicate parameters

Possible to use a PostgreSQL TYPE to define a dblink table?

use \set variable inside plpgsql declare block [duplicate]

postgresql plpgsql psql

Pass table to postgreSQL function, execute select statement, return table

Is it possible to create a table with a variable name in PostgreSQL?

sql postgresql plpgsql

PostgreSQL CREATE TEMPORARY TABLE inside a plpgsql function

Return multiple rows from plpgsql function

function postgresql plpgsql

PostgreSQL: Same request is slower with plpgsql language compared to sql

Returning boolean from SQL function

PostgreSQL plpgsql get current procedures oid

postgresql plpgsql

Postgres function: return multiple tables

Is there a way to catch exception of a deferred constraint in pgsql?

How to return a table's rowtype plus an additional column from a function?

How to disambiguate a plpgsql variable name in a ON CONFLICT clause?

PostgreSQL trigger not returning anything

postgresql triggers plpgsql