SQL Question
I'm trying to do some type of conditional select statement and I have no
idea how.
What I would like is something like this (using pseudo sql)
select (if(col1>1) true else if (col1<= 1) false) from foo;
does that make sense? Basically I want one column of my result set to be
true or false based on some logic. I can do it in code and have my program
handle it, but I was hoping to do it in SQL.
Thanks,
Matt O'Connor
Matthew <matt@ctlno.com> writes:
What I would like is something like this (using pseudo sql)
select (if(col1>1) true else if (col1<= 1) false) from foo;
This particular example could be written as just
select col1>1 from foo
since a boolean result is a perfectly good result.
More generally, you could use the CASE construct for conditional
expressions. See
http://www.postgresql.org/devel-corner/docs/postgres/functions-conditional.html
regards, tom lane