public inbox for [email protected]  

help / color / mirror / Atom feed

From: Pavel Stehule <[email protected]>
To: Robson Fidalgo <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Does Postgresql 8.3X support Object/Class Methods and association between objects with REF?
Date: Mon, 20 Apr 2009 14:28:33 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

2009/4/20 Robson Fidalgo <[email protected]>:
> 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;

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Does Postgresql 8.3X support Object/Class Methods and association between objects with REF?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox