[EMAIL PROTECTED] writes:
> I've been trying to figure out how to do the following:
> Select schedule.* from schedule join meetingday on schedule.id =
> meetingday.scheduleid where sessionnumber = 165 group by schedule.* order by
> min(meetingday.date);
I think what you're after is
select * fro
You need to create a custom aggregate for this
CREATE AGGREGATE array_accum (
sfunc = array_append,
basetype = anyelement,
stype = anyarray,
initcond = '{}'
);
then use the field names in your query like this
select array_to_string(array_accum(field1 || '@' || field2),'#')
I've been trying to figure out how to do the following:
Select schedule.* from schedule join meetingday on schedule.id =
meetingday.scheduleid where sessionnumber = 165 group by schedule.* order by
min(meetingday.date);
Is this possible in any way, or do I need to list each field of the schedul
