Re: allowed variable names in functions?

From: "A B" <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: allowed variable names in functions?
Date: 2008-06-30 11:01:19
Message-ID: dbbf25900806300401s7a5cab05w9a681a65fea3e5b3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Hilbert(at)gmx(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A B 2008-06-30 11:06:59 Re: allowed variable names in functions?
Previous Message A B 2008-06-30 10:50:39 Re: allowed variable names in functions?