[SQL] is there a 'table' data type in pg?

2007-07-24 Thread Louis-David Mitterrand
Hello, In my forum app a new post can be related to several types of objects: person, location, event, simple text subject, etc. so in my 'forum' table I plan to add an id_subject column which can contain a reference to any number of different tables (location, person, etc.). What I need to

Re: [SQL] is there a 'table' data type in pg?

2007-07-24 Thread Louis-David Mitterrand
On Tue, Jul 24, 2007 at 03:10:44PM +0100, Gregory Stark wrote: Louis-David Mitterrand [EMAIL PROTECTED] writes: Can I use a another column to store the type of the id_subject (ie: the tabled it belongs to) ? Then I would be able to query that table for additional info to print alongside

Re: [SQL] is there a 'table' data type in pg?

2007-07-24 Thread Peter Childs
On 24/07/07, Louis-David Mitterrand [EMAIL PROTECTED] wrote: On Tue, Jul 24, 2007 at 03:10:44PM +0100, Gregory Stark wrote: Louis-David Mitterrand [EMAIL PROTECTED] writes: Can I use a another column to store the type of the id_subject (ie: the tabled it belongs to) ? Then I would be able