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?