From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PL/pgSQL Copy data from one table to another |
Date: | 2014-02-08 21:11:00 |
Message-ID: | 1391893860864-5791096.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
George Ant wrote
> Hey Guys,
>
> Thank you for your replies! Your suggestions worked fine!! :) Also my code
> looks a lot cleaner now!
>
> Kind Regards,
> George Ant.
Have you considered just creating a view, or even retrieval functions, the
generate these "object forms" on the fly instead of altering your database
schema? Using arrays for master-detail relationships is typically
considered wrong and is definitely non-relational. Your application should
not dictate schema design to this level generally but instead you should add
an O-R layer where needed.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PL-pgSQL-Copy-data-from-one-table-to-another-tp5790663p5791096.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | George Ant | 2014-02-08 22:33:45 | Re: Dynamic insert into ARRAY? plpgsql |
Previous Message | David Johnston | 2014-02-08 20:57:45 | Re: Dynamic insert into ARRAY? plpgsql |