Re: Common Table Expressions applied; some issues remain

From: "Robert Haas" <robertmhaas(at)gmail(dot)com>
To: Decibel! <decibel(at)decibel(dot)org>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "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: 2008-10-06 20:04:23
Message-ID: 603c8f070810061304n55bb5ca7i9dbf80cfa58de998@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Agreed. It's already horrible that we suggest people use OFFSET 0, only
> because we don't want to define formal optimizer hints (and that's *exactly*
> what OFFSET 0 is).

Yes, especially since TFM says:

"OFFSET 0 is the same as omitting the OFFSET clause."

Unless I'm looking at the wrong part of the manual?

...Robert

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Emmanuel Cecchet 2008-10-06 20:54:42 Transactions and temp tables
Previous Message Grzegorz Jaskiewicz 2008-10-06 19:59:47 query path, and rules