Postgres Pro
Downloads
Home   >   mailing lists

Re: how to return ONE single record from a function in plpgsql? - Mailing list pgsql-sql

From Hubert depesz Lubaczewski
Subject Re: how to return ONE single record from a function in plpgsql?
Date
Msg-id 20030227155303.GB17157@depesz.pl
Whole thread Raw
In response to Re: how to return ONE single record from a function in plpgsql?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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"

pgsql-sql by date:

Previous
From: "Mark Connelly@South Central"
Date:
Subject: using Avg()
Next
From: Jack Kiss
Date:
Subject: Inquiry From Form [pgsql]