Postgres Pro
Downloads
Home   >   mailing lists

Re: Dynamic insert into ARRAY? plpgsql - Mailing list pgsql-general

From alexandros_e
Subject Re: Dynamic insert into ARRAY? plpgsql
Date
Msg-id 1391892164239-5791093.post@n5.nabble.com
Whole thread Raw
In response to Dynamic insert into ARRAY? plpgsql  (George Ant <g.antonopoulos000@gmail.com>)
Responses Re: Dynamic insert into ARRAY? plpgsql  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view 
You must a) join the 2 tables on the orderID ... where orderID=15 and then
GROUP BY the result by the order ID and concat the orderlines by a custom
aggregate function like:
http://www.postgresql.org/message-id/db7789b.0309131210.625da358@posting.google.com



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Dynamic-insert-into-ARRAY-plpgsql-tp5791090p5791093.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Dynamic insert into ARRAY? plpgsql
Next
From: David Johnston
Date:
Subject: Re: Dynamic insert into ARRAY? plpgsql