Result sets from functions

From: "Kevin Zapico" <kevin(dot)zapico(at)viewgate(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Result sets from functions
Date: 2002-01-10 08:23:01
Message-ID: a1jiuh$2i2a$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am new to postgres and am trying to get a function to return a result set
with multiple columns.

The only way I have seen to do this so far is

select column1(proc()), column2(proc())

This looks like it should call the proc() function twice, although I am sure
that it does not. However, I am trying to find out if there is another way
of doing this.

Please help.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gurudutt 2002-01-10 13:33:29 Resources
Previous Message Tom Lane 2002-01-10 01:59:04 Re: converting an epoch to a timestamp