From: Robert Treat <xzilla@users.sourceforge.net>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: control structures in plpgsql
Date: 12 Jun 2003 10:44:30 -0400
Message-ID: <1055429070.7086.319.camel@camel> (raw)
In-Reply-To: <20030612071842.S25608-100000@megazone23.bigpanda.com>
References: <20030612071842.S25608-100000@megazone23.bigpanda.com>
On Thu, 2003-06-12 at 10:24, Stephan Szabo wrote:
>
> On 12 Jun 2003, Robert Treat wrote:
>
> > Does anyone know if there is support for "IF x OR y THEN" syntax in
> > plpgsql? The docs just say IF [boolean expression] then. which loosely
> > interpreted could allow for an OR, but I couldn't seem to get it to
> > work. TIA,
>
> Can you give a full example of what you're trying? I'm not seeming to
> have a problem in 7.3 of saying something with an OR in it apart from
> needing to put parentheses around things for ordering in more complicated
> cases.
>
You beat me to my "please disregard the previous email" email ;-)
It works (in 7.2 btw), I was just programming in the wrong language
inside my plpgsql function.
Thanks for taking a look though.
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: xzilla@users.sourceforge.net, sszabo@megazone23.bigpanda.com
Subject: Re: control structures in plpgsql
In-Reply-To: <1055429070.7086.319.camel@camel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox