Horton

Re: BUG #5028: CASE returns ELSE value always when type is "char"

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joseph Shraibman <jks@selectacast.net>
Cc: Sam Mason <sam@samason.me.uk>, pgsql-bugs@postgresql.org
Date: 2009-09-01T18:17:00Z
Lists: pgsql-bugs 
Joseph Shraibman <jks@selectacast.net> writes:
> So the type of what is in the ELSE clause determines the type of the output?

If all the other branches are unknown literals, yes.

			regards, tom lane