Thread: All columns from table in a joined query

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
byschedule.* order by min(meetingday.date); 

Is this possible in any way, or do I need to list each field of the schedule table to get all of them?

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),'#') as field_alias from table_name

records will be seperated by '#'

hope this helps.

--
Thanks,
Sumeet Ambre
Masters of Information Science Candidate,
Indiana University.




--
Thanks,
Sumeet Ambre
Masters of Information Science Candidate,
Indiana University.

MHahn@seeandswim.com 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
groupby schedule.* order by min(meetingday.date);
 

I think what you're after is

select * from schedule where sessionnumber = 165
order by (select min(meetingday.date) from meetingday         where schedule.id = meetingday.scheduleid);
        regards, tom lane