Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

Multiple assignments in a single select

Are these two PostgreSQL functions equivalent? (RETURNS TABLE and RETURNS SETOF)

postgresql trigger error control reached end of trigger without RETURN

Easy way to have return type be SETOF table plus additional fields?

PostgreSQL: ERROR: $name$ is not a scalar variable

PostgreSQL: return a select statement in a procedure

Immediate update in PL/pgSQL functions

postgresql plpgsql

Error in postgres Cursor

postgresql plpgsql

POSTGRES, column "row_count" does not exist when using ROW_COUNT

postgresql plpgsql

PostgreSQL10, Pgcrypto, HMAC, how to recalculate data?

ERROR cursor does not exist after first loop in PL/pgSQL

sql postgresql plpgsql

Logging to a log table in a function shows the same time for all actions in it although they are minutes apart

postgresql plpgsql

Is it possible to create a function in PostgreSQL that takes a column name as input?

Passing array of a composite type to stored procedure

How can I print text to stdout from a psql query?

postgresql plpgsql

Query on subquery that gets tables' names

How To Restrict Delete using PL/pgSQL trigger?

Can I use an SQL statement in assignment inside a PL/pgSQL function?

sql postgresql plpgsql