Re: allowed variable names in functions? - Mailing list pgsql-general

From A B
Subject Re: allowed variable names in functions?
Date
Msg-id dbbf25900806300401s7a5cab05w9a681a65fea3e5b3@mail.gmail.com
Whole thread Raw
In response to Re: allowed variable names in functions?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: allowed variable names in functions?  ("A B" <gentosaker@gmail.com>)
List pgsql-general
But there not any problem with returning values with code like this

DECLARE
   retval  RECORD;

retval.c2 := ....
RETRUN NEXT retval;

if c2 is a field on some table?



2008/6/30 Karsten Hilbert <Karsten.Hilbert@gmx.net>:
> On Mon, Jun 30, 2008 at 12:44:31PM +0200, A B wrote:
>
>> By changing c2,c3,etc. to something else  xc2,xc3, etc. it worked!
>> So was the problem that I refered to the same names in the SELECT statement?
> Yes.
>
> Karsten
> --
> GPG key ID E4071346 @ wwwkeys.pgp.net
> E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: "A B"
Date:
Subject: Re: allowed variable names in functions?
Next
From: "A B"
Date:
Subject: Re: allowed variable names in functions?