Postgres Pro
Downloads
Home   >   mailing lists

Re: Repeating Append operation - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Repeating Append operation
Date
Msg-id 603c8f071003211329y28c37888v13cdb5941c326f05@mail.gmail.com
Whole thread Raw
In response to Repeating Append operation  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Responses Re: Repeating Append operation
List pgsql-hackers
Tree view 
On Fri, Mar 19, 2010 at 2:09 PM, Gurjeet Singh <singh.gurjeet@gmail.com> wrote:
>     Is there a way to avoid this double evaluation?

Maybe with a CTE?

WITH x AS (...) SELECT ...

It does look like surprising behavior.

...Robert

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: proposal: more practical view on function's source code
Next
From: Tom Lane
Date:
Subject: Re: proposal: more practical view on function's source code