Re: RETURNS SETOF primitive returns results in parentheses

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mario(dot)splivalo(at)mobart(dot)hr
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: RETURNS SETOF primitive returns results in parentheses
Date: 2005-10-26 19:45:33
Message-ID: 10931.1130355933@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr> writes:
> Wo-ha, makes perfect sense. So, I'd go by with declaring the rec as
> varchar, instead as of a record. Wich is what I should do in the first
> place.

Or just return the correct field out of it.

RETURN NEXT returnValue.fieldname;

I think you may have to do it this way because the FOR loop wants a
record variable.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2005-10-26 19:57:54 Re: RETURNS SETOF primitive returns results in parentheses
Previous Message Mario Splivalo 2005-10-26 19:41:39 Re: RETURNS SETOF primitive returns results in parentheses