Re: CASE eval issue

On Tue, Oct 18, 2011 at 03:42:10PM -0700, David E. Wheeler wrote:
> On Oct 18, 2011, at 3:31 PM, Aaron Burt wrote:
>
> > Query:
> > select id,
> > case has_column_privilege('mytable', 'secure_column', 'SELECT')
> > when FALSE then 'NA'
> > else secure_column
> > end as secure_column
> > from mytable where id=12345;
> >
> Try this:
>
> select id,
> case when has_column_privilege('mytable', 'secure_column', 'SELECT')
> then 'NA'
> else secure_column
> end as secure_column
> from mytable where id=12345;

Not sure I follow you. Your version appears to reverse the condition.
I did also use the 'case when (condition) then ...' form but as one would
expect, it acted the same. I also used explicit cases for TRUE and FALSE.

Thanks,
Aaron