Re: Nested CASE-WHEN scoping

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Nested CASE-WHEN scoping
Date: 2011-05-25 17:11:33
Message-ID: 23538.1306343493@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> writes:
> On 25.05.2011 17:47, Tom Lane wrote:
>> [ scratches head ... ] Why does the save/restore in ExecEvalCase not
>> take care of this?

> The mistake happens during planning, when the SQL function is inlined
> and pre-evaluated.

Hm. I'm inclined to think this may be more of a bug in the inlining
process than anything else. I have to run off for a doctor's
appointment, but will look at this closer later today.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2011-05-25 17:13:28 Re: [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum
Previous Message Greg Smith 2011-05-25 17:06:20 Re: tackling full page writes