Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

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

Multiple ALTER TABLE ADD COLUMN in one SQL function call

sql postgresql plpgsql

PL/pgSQL "Malformed array literal" error within for loop

arrays postgresql plpgsql

How to pass composite types to PL/pgsql function?

c# postgresql plpgsql npgsql