On Tue, Jan 5, 2010 at 3:30 PM, Antonio Goméz Soto <antonio.gomez.soto@xxxxxxxxx> wrote: > Hello, > > I have a column in a table that contains the name of another table, > and the id in that table. > > I would like to use this in a join statement. Is that possible? not possible I'm afraid. But have a look at concept of inheritance for something that might suit you. Or just store everything in one table, but add new id to each row. That is what other half of the world uses. Also, when writing queries like that, consider using aliases for table name, for instance: select a.id from animals a; makes life easier. hth -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
