Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in plpgsql

Pass multiple values in single parameter

Postgres function to show new column values after update as JSON

To sort the letters in a string alphabetically in PostgreSQL

How to access the whole current record within update statement

sql postgresql plpgsql

pl/pgsql vs prepared statements against sql injection attacks

How do I unnest an array inside a function?

arrays postgresql plpgsql

How to get results from a Postgresql function using EF Core?

PostgreSQL INSERT or UPDATE values given a SELECT result after a trigger has been hit

How to select into multiple variables inside a trigger function?

In plpgsql, how can I create and execute a command-string using on a variable number of identifiers?

Parallel safety and exception handling in Postgres

postgresql plpgsql

Postgres %% in function

sql postgresql plpgsql

Invalid input syntax for type integer: "(2,2)" with composite data type while executing function

How to migrate oracle's pipelined function into PostgreSQL

postgresql plpgsql

JPA & PostgreSQL: How do I call a stored procedure with void return type?

java postgresql jpa plpgsql

Convert string to column name

How to call a stored procedure in another procedure and use the result of it in the same procedure of Postgresql?

postgresql plpgsql

PostgreSQL update trigger Comparing Hstore values

Looping through a CURSOR in PL/PGSQL without locking the table