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
Post a Comment