Re: [SQL] aggregate query

2007-05-29 Thread Raj A
Thank you guys! I'm currently migrating an Oracle database to postgres and have created tables using the scripts that were readily available. Glad I can now improve this old system. On 29/05/07, Gregory Stark <[EMAIL PROTECTED]> wrote: "Andrew Kroeger" <[EMAIL PROT

[SQL] aggregate query

2007-05-28 Thread Raj A
I have a table CREATE TABLE survey_load ( meter_id character(5) NOT NULL, number_of_bays integer NOT NULL, bay_1_use integer, bay_2_use integer, bay_3_use integer, bay_4_use integer, bay_5_use integer, date date NOT NULL, inspection_id integer NOT NULL DEFAULT, ) How do i present an agg