| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: control structures in plpgsql |
| Date: | 2003-06-12 14:44:30 |
| Message-ID: | 1055429070.7086.319.camel@camel |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2003-06-12 16:55:51 | Re: (no subject) |
| Previous Message | Stephan Szabo | 2003-06-12 14:33:13 | Re: Some Questions |