2009/4/20 Robson Fidalgo <robson.fidalgo@gmail.com>:
> 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;
