Re: case when evaluating else condition anyway?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: case when evaluating else condition anyway?
Date: 2008-11-26 15:29:10
Message-ID: 8925.1227713350@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> writes:
> Still why does the else condition get evaluated anyway when at least
> one of the "when" condition is true?

Because 'literal'::type is a literal of that type; it does not represent
a run-time conversion. I think we document that under the discussion
of constants in the syntax chapter.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff MacDonald 2008-11-26 16:58:49 Re: pg_get_serial_sequence Strangeness/Unreliable?
Previous Message Sam Mason 2008-11-26 15:25:44 Re: case when evaluating else condition anyway?