From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PL/pgSQL 2 |
Date: | 2014-09-03 19:01:42 |
Message-ID: | 1409770902478-5817608.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This is more of an SQL request the pl/pgsql but is/has there been thought to
adding the ternary if/then opeator? Something like:
boolean_exp ?> val_if_true : val_if_false
using "?" by itself would be OK but not ideal - and the addition of the ">"
doesn't seem hateful...
Sorry if this is deemed off-topic but I just went to write
CASE WHEN boolean_exp THEN val_if_true ELSE val_if_false END
And the fact there is as much standard code as there is custom bothered me
just as is being discussed on this thread.
I'm going to go write a "ifthen(bool, anyelement, anyelement)" function
now....
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PL-pgSQL-2-tp5817121p5817608.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2014-09-03 19:16:47 | Re: PL/pgSQL 2 |
Previous Message | Robert Haas | 2014-09-03 18:48:45 | Re: PL/pgSQL 2 |