Re: [SQL] array_agg order by

2012-02-27 Thread Tom Lane
jdmorgan writes: > I am using a array_agg to get a subset of data to use in a > query.However, I can't figure out how to get the data returned in the > array_agg function to sort with an order by function.Any help would be > appreciated.Here is my query as it is now.I am using postgresql 8: We

[SQL] array_agg order by

2012-02-27 Thread jdmorgan
Hello, I am using a array_agg to get a subset of data to use in a query.However, I can't figure out how to get the data returned in the array_agg function to sort with an order by function.Any help would be appreciated.Here is my query as it is now.I am using postgresql 8: select pestproxsha