On Thu, 2003-02-06 at 22:55, terry@ashtonwoodshomes.com wrote:
> I have a date field, and if the status is X then I want to return the date,
> otherwise I want to return a null. Any ideas?
CASE should work:
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/functions-conditional.html
Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC