Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

How to loop through split string

sql postgresql plpgsql

How to insert multiple rows using a function in PostgreSQL

PL/pgSQL column name the same as variable

Column definitions in ROWS FROM() with multiple unnest calls

PostgreSQL function with a loop

How to remove duplicate rows with foreign keys dependencies?

pg_stat_activity doesn't update within a procedure or transaction

postgresql plpgsql

Cast produces 'Returned type character varying does not match expected type character varying(8)'

Update multiple columns in a trigger function in plpgsql

Split string with two delimiters and convert type

Can Postgres stored functions have both a return value AND out parameters?

Dynamically-generated table-name in PostgreSQL COPY command

postgresql plpgsql

Shredding XML in postgresql

xml postgresql plpgsql

PL/pgSQL anonymous code block

postgresql plpgsql

Loop through columns of RECORD

Array of arrays in PostgreSQL

sql postgresql plpgsql

PL/Proxy returning Unsupported Type on Stored Procedure Call

postgresql plpgsql

Reference psql parameter inside PL/pgSQL anonymous block

postgresql plpgsql psql

Weird now() time difference with Postgres triggers

Function as parameter to another function in Postgres