Re: How to avoid inlining subquery result columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to avoid inlining subquery result columns
Date: 2003-09-11 17:05:37
Message-ID: 28530.1063299937@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark <gsstark(at)mit(dot)edu> writes:
> I recall there was a way to defeat this optimization involving introducing an
> extra subquery layer somewhere.

I think adding "OFFSET 0" to a subquery is the simplest way to prevent
it from being flattened.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Bartlett 2003-09-11 17:08:48 Re: Picture with Postgres and Delphi
Previous Message Tomasz Myrta 2003-09-11 16:59:16 Re: MD5 function is not available ?