Re: Common Table Expressions applied; some issues remain - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Common Table Expressions applied; some issues remain
Date
Msg-id 4136ffa0905270410w57cb6c4ald8662f50370683ff@mail.gmail.com
Whole thread Raw
In response to Re: Common Table Expressions applied; some issues remain  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Common Table Expressions applied; some issues remain  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: Common Table Expressions applied; some issues remain  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, May 27, 2009 at 12:47 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I'm not too thrilled about that solution because it still eliminates
> predictability of execution of volatile functions.

How so? It means the volatile function might only be executed for the
matching rows but the rows will still have the same value for the same
rows for all references to the CTE which seems like the key property
to me.

-- 
greg


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: PostgreSQL Developer meeting minutes up
Next
From: Heikki Linnakangas
Date:
Subject: Re: Common Table Expressions applied; some issues remain