Skip site navigation (1) Skip section navigation (2)

setof (more than one column)

From: "Reinoud van Leeuwen" <reinoud(at)xs4all(dot)nl>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: setof (more than one column)
Date: 2002-01-03 14:11:11
Message-ID: 10000.194.109.0.126.1010067071.squirrel@webmail.xs4all.nl (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

I am doing some tests with functions in 7.2b4. I got some stuff to work 
that returns 'setof text' but I was wondering whether it is possble to let 
the function return more than one column, something like:

create function myfunc (integer) returns setof (text, integer)

or

create function myfunc (integer) returns setof text, integer

I've searched the docs about the syntaxt of the 'setof' keyword but could 
not find really much.

TIA,

Reinoud van Leeuwen


pgsql-hackers by date

Next:From: Tom LaneDate: 2002-01-03 15:05:24
Subject: Re: SET DATESTYLE to time_t style for client libraries?
Previous:From: Zeugswetter Andreas SB SDDate: 2002-01-03 13:02:05
Subject: Re: LWLock contention: I think I understand the problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group