| From: | "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com> |
|---|---|
| To: | |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Do AGGREGATES consistently use sort order? |
| Date: | 2007-09-06 18:43:43 |
| Message-ID: | b11ea23c0709061143pcdb8d45l2d54831d898dd446@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
order/aggregate thing is a general question.
>
> Yes.
>
> You can even do this with GROUP BY as long as the leading columns of the ORDER
> BY inside the subquery exactly matches the GROUP BY columns.
>
> In theory we can't promise anything about future versions of Postgres but
> there are lots of people doing this already so if ever this was lost there
> would probably be some new explicit way to achieve the same thing.
Does anyone have any spec links, oracle behavior, or whatever? For
now I will trust Postgres to continue behaving sanely, but I am
curious.
Thx to Gregory for the quick reply
>
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-09-06 18:55:33 | Re: ANY |
| Previous Message | Gregory Stark | 2007-09-06 17:51:01 | Re: Do AGGREGATES consistently use sort order? |