Composite type

Hello guys!

I have found a example in Oracle and I am trying to do it in Postgre.

Lets say that we have 2 tables.
Create Table "table1" Of "type1"
Create Table "table2" Of "type2"

I want to refer the first table in the second. I want to reference the whole
table not only one field, so something like that:

CREATE TYPE type2 AS OBJECT (
  var1   NUMBER,
  var2    REF type1
  )

CREATE TABLE table2 OF type2 (
   PRIMARY KEY (Pk),
   FOREIGN KEY (fk) REFERENCES table1)

Can i do something like this in Postgre?

Thank you in advance!
George Ant






--
View this message in context: http://postgresql.1045698.n5.nabble.com/Composite-type-tp5788860.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.