Re: "Join" on delimeter aggregate query - Mailing list pgsql-sql

From Tom Lane
Subject Re: "Join" on delimeter aggregate query
Date
Msg-id 17141.1055167576@sss.pgh.pa.us
Whole thread Raw
In response to "Join" on delimeter aggregate query  (Michael A Nachbaur <mike@nachbaur.com>)
List pgsql-sql
Eivind Kvedalen <eivindkv@ifi.uio.no> writes:
> Ok. What I actually had in mind was whether the optimizer would remove the
> ORDER BY clause completely or not,

No.  If you put an ORDER BY in a subselect, I think the system should
honor it.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: Re: Column limits in table/ views
Next
From: "Mendola Gaetano"
Date:
Subject: Re: Using a RETURN NEXT