Re: Changes in pl/pgsql? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Changes in pl/pgsql?
Date
Msg-id 20060522174929.GA10984@winnie.fuhr.org
Whole thread Raw
In response to Changes in pl/pgsql?  ("Michael Schmidt" <michaelmschmidt@msn.com>)
List pgsql-general
On Mon, May 22, 2006 at 11:20:04AM -0600, Michael Schmidt wrote:
> I've been going through functions for my database, originally
> developed with version 8.0, and had some odd behavior.  I'm in the habit
> of putting parentheses around the conditional clauses in IF statements.
> One of my trigger functions didn't work, but when the parentheses were
> deleted, it did.  Has something been changed in pl/pgsql for version
> 8.1.3?  Here is the statement.
>
> IF (NEW.is_individual) THEN ...
>
> where is_individual is a boolean field

Could you provide a standalone test case and explain what "didn't
work" means?  What were you expecting to happen and what actually
did happen?  How does 8.1.3's behavior differ from an earlier
version?  Exactly which earlier version behaves as expected?

--
Michael Fuhr

pgsql-general by date:

Previous
From: elein
Date:
Subject: Re: Let's make CPgAN!
Next
From: Martijn van Oosterhout
Date:
Subject: Re: "make check" fails over NFS or tmpfs