Return multiple columns and rows from a function PostgreSQL instead of record

by

Functions returning a table (or setof) should be used in the FROM clause:

select * 
from brand_hierarchy(1234)

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. Is SELECT or INSERT in a function prone to race conditions?
  3. Difference between language sql and language plpgsql in PostgreSQL functions
  4. How to return result of a SELECT inside a function in PostgreSQL?
  5. Pass multiple values in single parameter
  6. GROUP BY and aggregate sequential numeric values
  7. PL/pgSQL checking if a row exists
  8. PostgreSQL parameterized Order By / Limit in table function
  9. Return multiple fields as a record in PostgreSQL with PL/pgSQL
  10. PostgreSQL IF statement
  11. Call a set-returning function with an array argument multiple times
  12. Record returned from function has columns concatenated
  13. Postgres Dynamic Query Function
  14. Return setof record (virtual table) from function
  15. Window Functions or Common Table Expressions: count previous rows within range
  16. DROP FUNCTION without knowing the number/type of parameters?
  17. Postgres function returning table not returning data in columns
  18. COPY with dynamic file name
  19. pseudo_encrypt() function in plpgsql that takes bigint
  20. How to perform a select query in a DO block?
  21. Function with SQL query has no destination for result data
  22. Postgres trigger after insert accessing NEW
  23. Optimize GROUP BY query to retrieve latest row per user
  24. Check if value exists in Postgres array
  25. What is the difference between single quotes and double quotes in PostgreSQL?
  26. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  27. Best way to count rows by arbitrary time intervals
  28. Reference alias in WHERE clause
  29. Continuing a transaction after primary key violation error
  30. postgres – where in (list) – column does not exist

Leave a Comment