X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 2822E475CC7
	for <pgsql-sql@postgresql.org>; Thu, 27 Feb 2003 11:12:04 -0500 (EST)
Received: from postgresql.org ([64.49.215.8])
	by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with
	SMTP id 56511-07 for <pgsql-sql@postgresql.org>;
	Thu, 27 Feb 2003 11:11:50 -0500 (EST)
Received: from spike.esolution.pl (spike.esolution.pl [217.11.134.154])
	by postgresql.org (Postfix) with ESMTP id 48896475D0D
	for <pgsql-sql@postgresql.org>; Thu, 27 Feb 2003 10:54:00 -0500 (EST)
Received: from vu208.neoplus.adsl.tpnet.pl ([80.50.140.208] helo=depesz.pl)
	by spike.esolution.pl with esmtp (TLSv1:DES-CBC3-SHA:168) (Exim 4.12)
	id 18oQMB-0006SB-00; Thu, 27 Feb 2003 16:53:59 +0100
Received: from depesz by depesz.pl with local (Exim 4.12)
	id 18oQLH-0004Wc-00; Thu, 27 Feb 2003 16:53:03 +0100
Date: Thu, 27 Feb 2003 16:53:03 +0100
From: Hubert depesz Lubaczewski <depesz@depesz.pl>
To: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-sql@postgresql.org
Subject: Re: how to return ONE single record from a function in plpgsql?
Message-ID: <20030227155303.GB17157@depesz.pl>
Reply-To: depesz@depesz.pl
References: <20030223104731.GD11016@depesz.pl> <5776.1046018061@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2
Content-Disposition: inline
In-Reply-To: <5776.1046018061@sss.pgh.pa.us>
User-Agent: Mutt/1.4i
X-info-en-1: this message *may* reflect my personal opinion. it is *not*
X-info-en-2: intended  to  reflect  those  of  my  employer, or  anyone  else.
X-info-pl-1: wszelkie opinie =?iso-8859-2?Q?wyra=BFone_?=
	=?iso-8859-2?Q?w_tym_li=B6cie_prezentuj=B1_wy=B3=B1cznie_pogl=B1dy?=
X-info-pl-2: autora  listu.  opinie  =?iso-8859-2?Q?te_?=
	=?iso-8859-2?Q?w_=BFadnym__razie_nie__wyra=BFaj=B1__pogl=B1d=F3w?=
X-info-pl-3: pracodawcy   autora  =?iso-8859-2?Q?listu_?=
	=?iso-8859-2?Q?_ani__innych__zwi=B1zanych__z__nim__os=F3b=2E?=
X-Operating-System: Linux 2.4.18-xfs-1.1 i686 i686
X-Spam-Score: -2.8 (--)
X-Scanner: exiscan for exim4 (http://duncanthrax.net/exiscan/) with mks-vir
	(http://www.mks.com.pl) *18oQMB-0006SB-00*kTcYJleLovQ*
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200303/24
X-Sequence-Number: 12064

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"