Nested tables
От | Ferruccio Zamuner |
---|---|
Тема | Nested tables |
Дата | |
Msg-id | yam7509.442.155657056@mail.chierinet.it обсуждение исходный текст |
Ответы |
Re: [GENERAL] Nested tables
|
Список | pgsql-general |
Hi all, I'm relatively new to Postgres (V6.3.1), and I've come in trouble the following problem; I've defined the following: CREATE TABLE foo ( x int2 ); CREATE TABLE bar ( y foo, z int ); I read on some Postgres mailing digest that I had to put the OID of instance of foo into y field of bar. So I tried. The problem is that when I submit the following query: SELECT foo.x, bar.z WHERE foo.oid=bar.y; trying to catch int fields either from bar and from its instance of foo, Postgres replies that bar.y (of type foo) and foo.oid (of type oid) cannot be compared. I've also tried to cast them in many ways but the answer never changes! Any help would be greatly appreciated (I've completely missed the right way or just some detail?) Gianluca
В списке pgsql-general по дате отправления: