Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

What does %% in PL/pgSQL mean?

sql postgresql plpgsql

PostgreSQL 9.3: isnumeric() in a condition

How to pass custom type array to Postgres function

Running a SELECT in a PL/pgSQL block

postgresql 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