Re: Question about WHERE CASE - Mailing list pgsql-sql

Hi,

where requires a boolean expression, for instance
select * from stuff where true;

Hence "CASE WHEN $1=dir THEN TRUE ELSE metadir=$1 END" returns a boolean value everything is fine.

Regards martin

I have come across the following construct which works in postgres

WHERE CASE WHEN $1=dir THEN TRUE ELSE metadir=$1 END

via (https://stackoverflow.com/questions/49859153/filter-with-yes-no-and-all-in-postgres)

case when ('yes'= lower($1)) then (phone_number is not null)      when ('no'=lower($1)) then (phone_number is null)      else true end

I was always under the impression that a case expression could only be on the right side of a where expression ie:

WHERE fieldname=<cse expression>

Is this a postgres extention, cant find any documentation on this

thanks

Mike

-- 

Widdersdorfer Str. 415, 50933 Köln; Tel. +49 / 221 / 9544 010
HRB Köln HRB 75439, Geschäftsführer: Dr. Dirk Goldner, ppa. Melanie Lillich