[GENERAL] How tö select a column? - Mailing list pgsql-general

From Egon Frerich
Subject [GENERAL] How tö select a column?
Date
Msg-id fea93dc5-1f7a-1b75-a72b-53737bbb1203@frerich.eu
Whole thread Raw
Responses [GENERAL] Re: [GENERAL] How tö select a column?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [GENERAL] How tö select a column?  (Gavan Schneider <galeel.pendari@bigpond.com>)
List 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-----




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Next
From: "David G. Johnston"
Date:
Subject: [GENERAL] Re: [GENERAL] How tö select a column?