DECLARE DECLARE — define a cursor Synopsis DECLARE name [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO …| PostgreSQL Documentation
7.8. WITH Queries (Common Table Expressions) # 7.8.1. SELECT in WITH 7.8.2. Recursive Queries 7.8.3. Common Table Expression Materialization 7.8.4. Data-Modifying …| PostgreSQL Documentation
SELECT SELECT, TABLE, WITH — retrieve rows from a table or view Synopsis [ WITH [ RECURSIVE ] with_query [, …| PostgreSQL Documentation