function returns multiple columns as a single column instead of multiple columns

by

you need to call the function like this:

select * from foo(6);

which will return something like this:

project_id | project_name | project_type | project_description | project_status
-----------|--------------|--------------|---------------------|----------------
         6 | test project |      inbound |        inbound test |     processing

it’s a quirk of postgres that it can be called both ways and give you a result. you might want to check the docs on set returning functions some more, there are other ways to do this as well. Oh, there is a wiki page on it, written for plpgsql, but most applies to sql functions as well: http://wiki.postgresql.org/wiki/Return_more_than_one_row_of_data_from_PL/pgSQL_functions

More Related Contents:

  1. Why the “Group BY” by month didn’t work? [closed]
  2. Truncating all tables in a Postgres database
  3. How can I drop all the tables in a PostgreSQL database?
  4. How to change PostgreSQL user password?
  5. How to get the count of current month Sunday’s in psql?
  6. quick random row selection in Postgres
  7. Restore a postgres backup file using the command line?
  8. Running PostgreSQL in memory only
  9. How to close idle connections in PostgreSQL automatically?
  10. Refresh a materialized view automatically using a rule or notify
  11. postgresql – replace all instances of a string within text field
  12. Is it possible to have autoincrement number without it being an ID?
  13. PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
  14. How do I login and authenticate to Postgresql after a fresh install?
  15. Insert if not exists, else return id in postgresql
  16. psql: FATAL: database “” does not exist
  17. Difference between timestamps with/without time zone in PostgreSQL
  18. Omitting the double quote to do query on PostgreSQL
  19. Storing Images in PostgreSQL
  20. Psql could not connect to server: No such file or directory, 5432 error?
  21. Strange behaviour in Postgresql
  22. Cursor based records in PostgreSQL
  23. How to add column if not exists on PostgreSQL?
  24. Maximum characters in labels (table names, columns etc)
  25. Docker – Postgres and pgAdmin 4 : Connection refused
  26. Heroku database restore issue
  27. user postgres launches process that takes all CPUs 100% usage
  28. Postgres table column name restrictions?
  29. How do I get min, median and max from my query in postgresql?
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment