Re: how to return ONE single record from a function in plpgsql?

From: Hubert depesz Lubaczewski <depesz(at)depesz(dot)pl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: how to return ONE single record from a function in plpgsql?
Date: 2003-02-27 15:53:03
Message-ID: 20030227155303.GB17157@depesz.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sun, Feb 23, 2003 at 11:34:21AM -0500, Tom Lane wrote:
> You need to say
> reply helper_login%ROWTYPE;

thanks. i read the doc, but was misled by first line saying:
name tablename%ROWTYPE;

stupid me - i should heve keep on reading.

best regards

depesz

--
hubert depesz lubaczewski http://www.depesz.pl/
i choose to hate people when they're not polite; bruise me; that's allright.
bananafishbones "pow wow"

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Connelly@South Central 2003-02-27 16:59:26 using Avg()
Previous Message Christoph Haller 2003-02-27 14:41:53 Re: pgsql problem