New posts in plpgsql

Hashing a String to a Numeric Value in PostgreSQL

PL/pgSQL column name the same as variable

Select from a table variable

Postgres function returning table not returning data in columns

PostgreSQL Exception Handling

No function matches the given name and argument types

pseudo_encrypt() function in plpgsql that takes bigint

ERROR: unterminated quoted string at or near

Postgres SELECT ... FOR UPDATE in functions

SQL Sub queries in check constraint

PostgreSQL - Iterate over results of query

How can I ask user to enter the input in PostgresSQL/plpgsql?

Iterating over integer[] in PL/pgSQL

Error when setting n_distinct using a plpgsql variable

Format specifier for integer variables in format() for EXECUTE?

Replace empty strings with null values

How can I execute pl/pgsql code without creating a function?

PostgreSQL: How to DROP FUNCTION IF EXISTS without specifying parameters?

Test for null in function with varying parameters

How to write function for optional parameters in postgresql?