Re: noobie-ish question - selecting into a string

Ben,

> I'm wading my way through some postgresql that's just a little beyond me
> right now. (PG 7.3.4, PHP 4.3.4, Fedora Core 1)

Well, first off, that's an old version. 8.0.2 is current. If you're stuck
with 7.3, upgrade to the latest 7.3 (7.3.9) as there are known bugs in 7.3.4.
RPMs for Fedora are available.

> $chemical_query = "
> SELECT c.*
> , [this would be where I'm stuck...] as chemical_type_list
> FROM chemical c
> , chemical_chemical_type_map cctm
> WHERE c.chemical_id = cctm.chemical_id
> ORDER BY c.chemical_id
> ";

Custom aggregate. While this gets easier to do under 7.4, you can do it under
7.3. Look in the Docs under "Create Aggregate"; I beleive that there is an
example of a string concatination aggregate.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco