Re: immediate if function

From: Neil Conway <neilc(at)samurai(dot)com>
To: terry(at)ashtonwoodshomes(dot)com
Cc: "Postgres (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: immediate if function
Date: 2003-02-07 04:08:47
Message-ID: 1044590926.28519.36.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2003-02-06 at 22:55, terry(at)ashtonwoodshomes(dot)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(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Johnson 2003-02-07 04:55:49 Re: FreeBSD: SMP and PostgreSQL
Previous Message terry 2003-02-07 03:55:01 immediate if function