From: | Egon Frerich <egon(at)frerich(dot)eu> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | How tö select a column? |
Date: | 2017-02-18 16:33:02 |
Message-ID: | fea93dc5-1f7a-1b75-a72b-53737bbb1203@frerich.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-02-18 16:38:52 | Re: [GENERAL] How tö select a column? |
Previous Message | Adrian Klaver | 2017-02-18 15:02:36 | Re: Autovacuum stuck for hours, blocking queries |