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 aggregate query inspection_id | meter_id | bay_use 1 12345 (value of bay_1_use) 1 12345 (value of bay_2_use) 1 12345 (value of bay_3_use) 2 23456 (value of bay_1_use) 2 23456 (value of bay_2_use) 2 23456 (value of bay_3_use) 2 23456 (value of bay_4_use) 2 23456 (value of bay_5_use) Thanks ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
