Logo Questions Linux Laravel Mysql Ubuntu Git Menu

New posts in plpgsql

Is there any shortcut to declare several variables of the same type in plpgsql?

Splitting SQL result into groups with max size = n

sql postgresql plpgsql

PostgreSQL: Adding an interval to a timestamp in a different time zone

structure of query does not match function result type

postgresql plpgsql

PostgreSQL trigger after update only on a updated row

PostgreSQL stored procedure data parameter

postgresql plpgsql

Substitute for MySQL's variables in PostgreSQL?

Window Functions or Common Table Expressions: count previous rows within range

postgresql: syntax error at or near "DO"

Returning multiple values from UPDATE query in PostgreSQL

Savepoint in PostgreSql Function

PostgreSQL 11 - Procedures

How to make queries atomic in PostgreSQL stored procedures?

Rollback Transaction on Trigger ERROR

IS NOT NULL test for a record does not return TRUE when variable is set

sql postgresql null row plpgsql

A function calculating average age in years in SQL [postgresql]

How do I use variables in a postgresql function for loop query

Postgres Function Slower than Query / Postgres 8.4

How to return a value inside a postgreSQL PL/pgSQL EXECUTE

postgresql plpgsql

How to shuffle array in PostgreSQL 9.6 and also lower versions?