2009/4/20 Robson Fidalgo <robson.fidalgo@xxxxxxxxx>: > Hello, > I am study the relational-object paradigm with postgresql 8.3X and I know > that it supports composite and/or array attributes. However, I didn't find > documentation/examples about the usage of Object/Class Methods and > association between objects with REF (like oracle does). Then, I'd like to > know if theses concepts (Method and REF) are supported by postgresql 8.3X? > I've searched the mailing lists and have found little about the OR features. > There is some book or URL with a good material about postgres 8.3 OR > features? Below follows an example (Son has a REF for his Father and a > get_name method) in oracle. Then, how can I do a similar example in > Postgresql 8.3X? (Just a code example help me! You don't need explain the > example.) > > Thanks in advances, Hello this feature isn't supported regards Pavel Stehule > > Robson. > > CREATE TYPE tp_father AS OBJECT ( > name varchar2(60)); > > CREATE OR REPLACE TYPE BODY tp_father AS > MEMBER FUNCTION get_name RETURN varchar2 IS > BEGIN > RETURN name; > END; > END; > > CREATE TYPE tp_son AS OBJECT ( > name varchar2(60), > father REF tp_father); > > CREATE TABLE father OF tp_father; > CREATE TABLE son OF tp_son; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
