DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=w1XUophlGxQCfXrn6r8icRaY2slCi+yfKBKQI+2B8CD//z0lCROkl0tXpMFDdW0RLD
	NJ4nvLr1U61gXLSwi+gQQk3iP/uLgnuHR98980MRFWISiyrJSKp/S+aaBenhhmUWZ1C/
	sSQTpro0gLgIIiy51oP4br97Hwa0UuTHPflVs=
MIME-Version: 1.0
In-Reply-To: <41534c40904200505j356ae308jb5528daeeb27a004@mail.gmail.com>
References: <41534c40904200505j356ae308jb5528daeeb27a004@mail.gmail.com>
Date: Mon, 20 Apr 2009 14:28:33 +0200
Message-ID: <162867790904200528p2c83fcc2p982156d90a5f65ca@mail.gmail.com>
Subject: Re: Does Postgresql 8.3X support Object/Class Methods and
	association between objects with REF?
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Robson Fidalgo <robson.fidalgo@gmail.com>
Cc: pgsql-docs@postgresql.org, pgsql-general@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 fin=
d
> documentation/examples about the usage of Object/Class Methods and
> association between objects with REF (like oracle does). Then, I'd like t=
o
> 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 featur=
es.
> 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)=C2=A0in oracle. Then, how can I do a similar example in
> Postgresql 8.3X?=C2=A0(Just a code example help me! You don't need explai=
n the
> example.)
>
> Thanks in advances,

Hello

this feature isn't supported

regards
Pavel Stehule

>
> Robson.
>
> CREATE TYPE tp_father AS OBJECT (
> =C2=A0name varchar2(60));
>
> CREATE OR REPLACE TYPE BODY tp_father AS
> =C2=A0 MEMBER FUNCTION get_name RETURN varchar2 IS
> =C2=A0=C2=A0=C2=A0=C2=A0 BEGIN
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 RETURN name;
> =C2=A0=C2=A0=C2=A0=C2=A0 END;
> END;
>
> CREATE TYPE tp_son AS OBJECT (
> =C2=A0 name varchar2(60),
> =C2=A0 father REF tp_father);
>
> CREATE TABLE father OF tp_father;
> CREATE TABLE son OF tp_son;