Re: OID's - Mailing list pgsql-general

From Greg Stark
Subject Re: OID's
Date
Msg-id 8765458qx0.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: OID's  (Matt <matt@kynx.org>)
Responses Re: OID's  (Matt <matt@kynx.org>)
List pgsql-general
Matt <matt@kynx.org> writes:

> I ask because I'm currently using them to join a single table to rows in
> arbitrary tables, something like:
>
> +-------------+
> | JOINME      |
> +-------------+
> | foreign_oid |
> | foreign_id  |
> | ...         |
> +-------------+
>
> Where foreign_oid is the tableoid of the table and foreign_id is the
> (serial, not oid) id of the row in that table.
>
> I dunno if it's bad design, but it's darn handy.

How do you make use of this? It seems like you would need your code to know
which foreign_oid referred to which table to actually perform the join.


--
greg

pgsql-general by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: Fwd: Problem installing Postgresql on MDK10.0
Next
From: Tom Lane
Date:
Subject: Re: How to overload POSITION