Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

PostgreSQL return table with update and select statement causing ambiguity

PostgreSQL: Checking for NEW and OLD in a function for a trigger

postgresql run external sql script from inside function

postgresql plpgsql

Can I iterate over NEW in a PostgreSQL trigger function?

How to XML-encode a string in PostgreSQL?

Adding ST_Transform in a PL/pgSQL function

PostgreSQL 9.3 trigger function to insert into table with parameterized name

PostgreSQL trigger prevents another one to work

Splitting comma separated string in PL/pgSQL function

sql postgresql plpgsql

Trying to create aggregate function in PostgreSQL

In PostgreSQL, how can you declare a variadic function that accepts arguments of differing types?

postgresql plpgsql

PostgreSQL: `unnest` an array and then `array_agg` it back

postgresql plpgsql

Store regexp_matches result in variables

Trigger on UPDATE to DELETE rows in another table depending on a third table

How to use PL/pgSQL to construct a table with dynamic columns

Raise error without rollback in plpgsql/postgresql

postgresql plpgsql

Similar UTF-8 strings for autocomplete field

How do you use LIKE query for enum in rails?

Postgresql - Compare a string with a null value

Sanitize user input with the USING keyword in PL/pgSQL