On Sun, Sep 26, 2010 at 9:37 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> > The SQL standard explicitly disavows any particular > output row order unless there is a top-level ORDER BY. (In fact, > unless things have changed recently an ORDER BY in a sub-select isn't > even legal per spec.) > > Not sure about the SQL spec allowing it, but an ORDER BY followed by a LIMIT does have valid use cases in sub-selects. Regards, -- gurjeet.singh @ EnterpriseDB - The Enterprise Postgres Company http://www.EnterpriseDB.com singh.gurj...@{ gmail | yahoo }.com Twitter/Skype: singh_gurjeet Mail sent from my BlackLaptop device
