Home > mailing lists

Question about WHERE CASE - Mailing list pgsql-sql

From	Mike Martin
Subject	Question about WHERE CASE
Date	September 5, 2019 14:04:39
Msg-id	CAOwYNKYVz67+qK6QfSiJVhCA8fAXzpHLS-L9HG=SEhOUzJ0A1w@mail.gmail.com Whole thread Raw
Responses	Re: Question about WHERE CASE Re: Question about WHERE CASE
List	pgsql-sql

I have come across the following construct which works in postgres

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

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

From: Sebastien FLAESCH
Date: 30 August 2019, 16:55:35
Subject: Re: libpq: How are result sets fetched behind the scene?

From: Martin Stöcker
Date: 05 September 2019, 14:42:57
Subject: Re: Question about WHERE CASE