Re: [SQL] Return relation table data in a single value CSV

2004-02-18 Thread Richard Huxton
On Tuesday 17 February 2004 23:33, Tom Lane wrote: > Richard Huxton <[EMAIL PROTECTED]> writes: > > 2. Write a custom aggregate function (like sum()) to do the > > concatenation. This is easy to do, but the order your ABC get processed > > in is undefined. > > Actually, as of 7.4 it is possible to

Re: [SQL] Return relation table data in a single value CSV

2004-02-17 Thread Tom Lane
Richard Huxton <[EMAIL PROTECTED]> writes: > 2. Write a custom aggregate function (like sum()) to do the concatenation. > This is easy to do, but the order your ABC get processed in is undefined. Actually, as of 7.4 it is possible to control the order of inputs to a custom aggregate. You do some

Re: [SQL] Return relation table data in a single value CSV

2004-02-17 Thread Richard Huxton
On Tuesday 17 February 2004 20:05, [EMAIL PROTECTED] wrote: > I should probably be punished for even asking this question, but a > simplified version of what I want is this... > > I have 2 tables: > floorplans > floorplan_id | description > -- > 2240 | test floorplan

[SQL] Return relation table data in a single value CSV

2004-02-17 Thread terry
I should probably be punished for even asking this question, but a simplified version of what I want is this... I have 2 tables: floorplans floorplan_id | description -- 2240 | test floorplan and a table elevations floorplan_id | elevation