Postgres Pro
Downloads
Home   >   mailing lists

Thread: [GENERAL] How tö select a column?

[GENERAL] How tö select a column?

From
Egon Frerich
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I have a table with two columns with type money. If column 'a' has an
amount > 0 then this amount is wanted else the amount from column 'b'.

How could I do this?

Thanks.

Egon


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)

iQIcBAEBAgAGBQJYqHc9AAoJECc7nbY+bg5uvT0P/0d00WyZtRQdrldVCy11GEJN
UyYgOqktgURYWfurZYD0Q//ARFbdWn+kAl3Ifk8P23iRfzA+wZQ28qKrM5MODmtN
AVVuwTCKJG00lLriR9tzWnnbWNyFEjG4aZHfa7RsvIc27uoqyj19Hjr37mrxtvOI
j0GPpp/sH8KQqloyh7I26TzOlMlQcMf7gHRoLXC0JPwZWLTAYVjmVfKU2ZXSbkFB
cTHOv5hfZ3XHXFftMqJDTsGYp/nG7nTdPpIWV3L9uyP2dmiBlZNlbgQsEQkpsYx9
WHA8NK9TWU02io6KpEsA/yxxPnZDMYaezXlnaT4VYjXrJa7aM85c2whmqEXKSl8n
cy/9wG1w1MLR0HGheT+9MmzHMEQbXhCbIKH1vV+3KXIRu6cRmc5YfCMVykOsgC8A
Z6VufOBq0c2NVqeDUm7aKy2z89CxNvs88Ixz2O/+qeIGURjw2pSeWS7N2mN4W2Jh
Zwnr3GBJufREUM55W+ACdO1LPr3cFY9M1o+92rw+KUKFZ50DMz7mP8h50OzIHX3o
gl8cgu+OydmSSes5/BEWuQT7Q8dUpxEztgiR39wBhkGvsL9hldXVz6AC0T3x177u
5UJABse/6i1qViuq4HcZK9OQbkNECeKTTNpPJszd/S5hAKOnt4Vg/0kDUbwm1Qwj
Rj6uIKDRpSY/5kl36kX6
=6A2K
-----END PGP SIGNATURE-----

[GENERAL] Re: [GENERAL] How tö select a column?

From
"David G. Johnston"
Date:
On Sat, Feb 18, 2017 at 9:33 AM, Egon Frerich <egon@frerich.eu> wrote:
I have a table with two columns with type money. If column 'a' has an
amount > 0 then this amount is wanted else the amount from column 'b'.

​https://www.postgresql.org/docs/9.6/static/functions-conditional.html

SELECT CASE WHEN a > 0 THEN a ELSE b END AS a_or_b FROM tbl​;

David J.

Re: [GENERAL] How tö select a column?

From
Gavan Schneider
Date:
On 2/18/17 at 3:33 AM, Egon Frerich wrote:

>I have a table with two columns with type money. If column 'a' has an
>amount > 0 then this amount is wanted else the amount from column 'b'.
>
Examples in 4.2.14

SELECT CASE WHEN a > 0 THEN a ELSE b END FROM <money_table>
WHERE <whatever>;

Regards
Gavan Schneider