Re: [SQL] Can't Get SETOF Function to Work

2005-11-01 Thread Lane Van Ingen
It worked perfectly! Thank you so much for your help! -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 01, 2005 7:45 PM To: Lane Van Ingen Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Can't Get SETOF Function to Work On Tue, Nov 01, 2005

Re: [SQL] Can't Get SETOF Function to Work

2005-11-01 Thread Michael Fuhr
On Tue, Nov 01, 2005 at 04:38:12PM -0500, Lane Van Ingen wrote: > Have tried perhaps 20+ alternatives on this plpgsql function, but can't get > it to work. Suspect I have done something wrong either with RETURN values, > creating of a type, or (most likely) use of ROW(). > ... > CREATE OR REPLACE F

[SQL] Can't Get SETOF Function to Work

2005-11-01 Thread Lane Van Ingen
Have tried perhaps 20+ alternatives on this plpgsql function, but can't get it to work. Suspect I have done something wrong either with RETURN values, creating of a type, or (most likely) use of ROW(). I am trying to fix the returned rows from enclosing reults in parenthesis; found a similar incid