Can I create and access a table in the same SQL function?...

Why can PL/pgSQL functions have side effect, while SQL functions can't?...

How to prevent 'invalid input syntax for type json' in Postgres, when records contain a mix ...

How to return a set of composite type without cast in PL/pgSQL?...

Avoid checks for each row, replace query by function?...

Postgresql 8.4 update query syntax error in plpgsql function...

Declare variable set = select...

Invalid input syntax for integer POSTGRESQL...

Stored procedure with inserts to two related tables failing on foreign key constraint...

PostgreSQL PL/pgSQL random value from array of values...

How can I optimize case statement with similar condition in PostgreSQL?...

PL/pgSQL - %TYPE and ARRAY...

How to generate an array of given size, with one field populated?...

How do I get the type of an array's elements?...

How to extract file extension from filepath field in PostgreSQL?...

Caching when using a loop in PL/pgSQL...

Is a good idea do processing of a large amount of data directly on database?...

How to use dynamic names in a column definition list?...

What are '$$' used for in PL/pgSQL...

How to SELECT without error if table does not exist...

EXPLAIN ANALYZE within PL/pgSQL gives error: "query has no destination for result data"...

Declaring a cursor in plpgsql fails...

ERROR: syntax error at or near "QUERY" QUERY EXECUTE 'set enable_parallel_append = off...

Unnest multiple arrays in parallel...

Delete data from child tables with Stored Procedure...

Variables for identifiers inside IF EXISTS in a plpgsql function...

Count rows affected by DELETE...

Using variables in a PL/pgSQL function...

How to query a table whose name is built from a PL/pgSQL function result?...

column does not exist when function return query execute plpgsql...