Re: All columns from table in a joined query

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.

On 8/23/06, MHahn(at)seeandswim(dot)com <MHahn(at)seeandswim(dot)com> wrote:
>
> 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
> schedule table to get all of them?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

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

On 8/23/06, MHahn(at)seeandswim(dot)com <MHahn(at)seeandswim(dot)com> wrote:
>
> 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
> schedule table to get all of them?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

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