Обсуждение: control structures in plpgsql
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
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.
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