Re: OID's

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: OID's
Дата
Msg-id 8765458qx0.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: OID's  (Matt <matt@kynx.org>)
Ответы Re: OID's  (Matt <matt@kynx.org>)
Список 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 по дате отправления:

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: Fwd: Problem installing Postgresql on MDK10.0
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How to overload POSITION