Re: PL/pgSQL 'i = i + 1' Syntax

From: Mark Dilger <pgsql(at)markdilger(dot)com>
To: David Wheeler <david(at)kineticode(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PL/pgSQL 'i = i + 1' Syntax
Date: 2006-05-17 00:02:15
Message-ID: 446A6807.8070607@markdilger.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Wheeler wrote:
> On May 16, 2006, at 16:53, Mark Dilger wrote:
>
>> Sorry, I meant to say that it should only be a no-op according to the
>> language
>> specification, as I understand it. The fact that it works suggests
>> to me that
>> the implementation of PL/pgsql has been modified (or broken?).
>> Whether the
>> change is a bug or an intentional feature change, I don't know.
>
>
> Ah, yes, I agree, and that's why I posted my query.
>
>> mark
>>
>> P.S., Looking through the documentation, I don't immediately see the
>> spec for
>> how a regular '=' is supposed to work, but assignment is documented
>> as using the
>> ':=' syntax and says nothing about '='.
>
>
> Exactly. But I use = all the time for comparision:
>
> IF FOUND = TRUE THEN
> ....
> END IF
>
> Best,
>
> David

It seems this has been answered before, by Tom Lane:

http://archives.postgresql.org/pgsql-novice/2006-04/msg00138.php

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Wheeler 2006-05-17 00:07:25 Re: PL/pgSQL 'i = i + 1' Syntax
Previous Message David Wheeler 2006-05-16 23:58:12 Re: PL/pgSQL 'i = i + 1' Syntax