If test in sql?? - Mailing list pgsql-general

From Esa Pikkarainen
Subject If test in sql??
Date
Msg-id 67915E45708@ktk.oulu.fi
Whole thread Raw
Responses Re: If test in sql??  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-general
This is maybe a novice question, but after all...
Say, I have a discussion forum application. There is an expiration
value for a whole board; then there are individual values for every
conference. If this individual value is NULL then the general value
should be used. How can I test this situation in a query (to
Postgresql):
I mean something like:

  Select (IF conf.expire NOTNULL conf.expire ELSE gen_expire)
  as expire, ...

Where is this in manuals if it is?

Thanks
Esa

pgsql-general by date:

Previous
From: Zak McGregor
Date:
Subject: Re: Re: MySQL has transactions
Next
From: "Oliver Elphick"
Date:
Subject: Re: [INTERFACES] Can't connect to anonCVS !