Re: Error with returning SETOF Record - Mailing list pgsql-hackers

From A E
Subject Re: Error with returning SETOF Record
Date
Msg-id 20031227215729.95642.qmail@web12104.mail.yahoo.com
Whole thread Raw
In response to Re: Error with returning SETOF Record  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Error with returning SETOF Record
List pgsql-hackers
I guess the question I have then is how do I return data from a select statement using the record datatype? This is only a test function I was trying to get info from, but my application is based on passing the table name to the function dynamically. How do I do this? The documentation is sketchy when it comes to the record datatype.
 
TIA
Alex

Tom Lane <tgl@sss.pgh.pa.us> wrote:
A E writes:
> CREATE FUNCTION tester(varchar) RETURNS SETOF record as'
> DECLARE
> ft record;
> begin
> FOR ft IN SELECT * FROM visaapplicants LOOP
> RETURN NEXT ft;
> END LOOP;
> return null;
> end;'
> LANGUAGE 'plpgsql' VOLATILE;

>
> select * from tester('a') as (c varchar);

>
> ERROR: wrong record type supplied in RETURN NEXT
> CONTEXT: PL/pgSQL function "tester" line 6 at return next

That's pretty much what I'd expect, unless table visaapplicants contains
only a single varchar column. The example works fine for me if I define
visaapplicants that way.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an in dex scan if your
joining column's datatypes do not match

pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: [GENERAL] Strange permission problem regarding pg_settings
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Strange permission problem regarding pg_settings