Re: Common Table Expressions applied; some issues remain

From: Greg Stark <stark(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Yoshiyuki Asaba <y-asaba(at)sraoss(dot)co(dot)jp>, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Common Table Expressions applied; some issues remain
Date: 2009-05-27 11:10:50
Message-ID: 4136ffa0905270410w57cb6c4ald8662f50370683ff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, May 27, 2009 at 12:47 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2009-05-27 11:20:01 Re: Common Table Expressions applied; some issues remain
Previous Message Magnus Hagander 2009-05-27 11:05:08 Re: PostgreSQL Developer meeting minutes up