"and then" / "or else"

From: Christian Schröder <cs(at)deriva(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: "and then" / "or else"
Date: 2007-11-17 08:53:40
Message-ID: 473EAC14.2010706@deriva.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list,
the logical operators "and" and "or" are commutative, i.e. there is no
"short-circuiting". Especially when doing PL/pgSQL development it would
sometimes be very handy to have this short circuiting. Unfortunately,
the trick from the docs (chapter 4.2.12) using "case ... then" does not
work inside an "if" statement (the "then" of the "case" is interpreted
as belonging to the "if" and thus leads to a syntax error).
Of course, I can sometimes use nested "if" statements, but that doesn't
always meet the logical requirements and leads to less readable code.
Some programming languages (e.g. Eiffel) know the operators "and then"
and "or else" which explicitly are "short-circuited". Would it be
possible to add these operators to PostgreSQL in general or at least to
the PL/pgSQL syntax?

Regards,
Christian

--
Deriva GmbH Tel.: +49 551 489500-42
Financial IT and Consulting Fax: +49 551 489500-91
Hans-Böckler-Straße 2 http://www.deriva.de
D-37079 Göttingen

Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2007-11-17 13:20:16 Re: "and then" / "or else"
Previous Message Tom Lane 2007-11-17 05:36:35 Re: pg_dump not including custom CAST?