Thread: control structures in plpgsql

control structures in plpgsql

From
Robert Treat
Date:
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,

Robert Treat

-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL



Re: control structures in plpgsql

From
Stephan Szabo
Date:
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.




Re: control structures in plpgsql

From
Robert Treat
Date:
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