Simple function - Mailing list pgsql-general

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/