David Fetter wrote: > > On Mon, Apr 30, 2007 at 10:51:36PM -0700, novnov wrote: >> >> Does postgresql have a built in IF function that allows one to eval a >> condition and return one or another value? Like: >> >> IIF(mybooleanfield = true, "It's true", "It's not true") > > It has CASE, as in > > CASE foo WHEN true THEN 'It''s true' ELSE 'It''s not true' END; > > Cheers, > D > -- > David Fetter <[EMAIL PROTECTED]> http://fetter.org/ > phone: +1 415 235 3778 AIM: dfetter666 > Skype: davidfetter >
I didn't express myself clearly. Is there an IIF type function one can use inline in a view? SELECT UserName, IIF(mybooleanfield = true, "It's true", "It's not true") as SayIt FROM tblUser I don't think there is, and I don't 'need' it, just could be handy once in a while. -- View this message in context: http://www.nabble.com/IF-function--tf3673523.html#a10270049 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
