sql - Postgresql function returns composite - how do I access composite values as separate columns? -


I have a Postgresql function that defines as a composite type (location text, id INT). When I run "SELECT myfunc ()", my output is a type of text that is formatted:

  ("locationdata", myid)  

It's terrible that I have a way of making an overall selection, so that I get 2 columns back - a text column and an INT column?

Use:

  SELECT * myfunc ()  

You can


Comments