Hello Erik,

EDL> Yes, I know about the CASE construct. I have read the sample in the doc
EDL> files (and in Helen's book), but, as in any other language, you could use a
EDL> CASE in each case (pun intended) you now use an IF.
EDL> It's just that an IF would be more logical here (with less code to write).

I don't know if either CASE or IF statement conforms SQL language
standard at all... You can use IF statement in PSQL extension of SQL
language (stored procedures and triggers), but I guess you don't need
it in your particular case :)


--
Best regards,
Pavel Menshchikov
http://www.ls-software.com