Hi guys, I have a table with two integer fields (field1 and field2)...
I would like to construct a function that perform an operation with this two fiels (field1 + fields2), and return the string value "A" if the sum is <20, "B" if the sum is >=20 or <=50, and finally return "C" if the sum is >50. So I would do: "SELECT id,function() FROM mytable;" and get rows like these: 001 A 002 A 003 C 004 C 005 C 006 B ... Could you help me??? Thanks in advance, See ya, Marcelo __________________________________________________ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html