Re: [SQL] Permanent alias for postgresql table

2009-03-13 Thread Mina R Waheeb
reign keys. If you really have a lot of objects represented in tables and you plan to have unknown number of versions for each table/object then I believe you should reconsider your approach. Best regards, Mina R Waheeb On Thu, Mar 12, 2009 at 6:54 PM, Lennin Caro wrote: > > -- On T

[SQL] SQL/XML Multi table join question

2008-04-16 Thread Mina R Waheeb
Hi all, I have the following tables (parent and two children) CREATE SEQUENCE person_seq; CREATE TABLE person( _id integer DEFAULT nextval('person_seq') NOT NULL, _timestamp TIMESTAMP NOT NULL, _lastModified TIMESTAMP NOT NULL, name VARCHAR(255) NOT NULL,