Converting function from Oracle to PostgreSQL...

Triggers are not executed when a field is changed via NEW...

Passing array to WHERE IN on multiple columns in a function...

Postgresql- trigger to insert and then to truncate table...

Loop on tables with PL/pgSQL in Postgres 9.0+...

postgresql round half down function...

syntax error when creating an if statement on postgresql function...

Special variable FOUND not set properly?...

How to convert integer[] to jsonb in a PL/pgSQL code block...

Store query result in a PL/pgSQL variable...

Dynamic SQL (EXECUTE) as condition for IF statement...

Dynamically generate columns for crosstab in PostgreSQL...

Access and return result from INSERT INTO in PL/pgSQL function...

Incrementing a number in a loop in plpgsql...

How to find the first and last occurrences of a specific character inside a string in PostgreSQL...

Find the statement currently running in my PL/pgSQL code block...

Can 2 postgresql functions be called in parallel?...

dblink can't update a table on the same database in an after UPDATE trigger...

Perform action before exception call in Postgres trigger function...

PostgreSQL : when using RAISE NOTICE in psql, can I avoid the "NOTICE :" prefix from the o...

Loop in function does not work as expected...

Update record of a cursor where the table name is a parameter...

How to declare variables and use them to UPDATE each row based on the preceding row(s)...

How do I drop all invalid indexes in postgres?...

How to allow mixed integer and numeric parameters in icase...

Cast value to type (TEXT) using string representation of type ("TEXT")...

Find SUM and MAX in custom aggregate function...

postgres event trigger and function not working...

concatenate additional text to string variable in pl/pgsql...

How to commit when inserting records by calling Postgres function...