Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

PL/pgSQL: PERFORM vs CALL

PL/pgSQL function to INSERT array of rows

arrays postgresql plpgsql

How to trim double quotes from string variable in postgreSQL function

sql postgresql plpgsql

Why the same IMMUTABLE function takes more time than STABLE?

trigger to save data when fails INSERT on another table?

postgresql plpgsql

Return a query from a function?

Generate unique random strings in plpgsql

sql postgresql random plpgsql

a postgres update trigger performs everything else except the actual update

postgresql triggers plpgsql

Generate dates for a specific week of year

Is a PostgreSQL function marked as STABLE allowed to acquire locks?

Postgres IN operator raises ERROR: syntax error at or near array_variable

sql postgresql plpgsql

How to do global exception handler in postgres?

Updating integer column from jsonb member fails with: column is of type integer but expression is of type jsonb

Postgres PL/pgSQL recursive calculation

PostgreSQL Return affected rows by UPDATE/INSERT query

sql postgresql return plpgsql

postgresql trying to call update returning multiple rows

sql postgresql plpgsql

Use function variable in dynamic COPY statement

postgresql plpgsql

plpgsql Postgresql functions for calculating skewness and kurtosis

Syntax error when declaring a postgres variable [duplicate]