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