Question on the right way to think about order by - Mailing list pgsql-general

From Paula Kirsch
Subject Question on the right way to think about order by
Date
Msg-id CAHaXFP+cZ61H6UWV4iNsoRkHp=hNaydbeVSKD8iryimfbMYG3Q@mail.gmail.com
Whole thread Raw
Responses Re: Question on the right way to think about order by  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
When I think about using order by in a select statement, e.g.

select id, name, price from stuff order by name;

I think of order by as an operator sorting data returned by the select statement.

When I think about order by in an aggregate statement, e.g.

select string_agg(product, ' | ' order by product) from products;

is it correct to think of order by as a parameter passed to string_agg?

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Cloning schemas
Next
From: "David G. Johnston"
Date:
Subject: Re: Question on the right way to think about order by