Re: Support for persistant objects in PostgreSQL? - Mailing list pgsql-hackers

From Jeff
Subject Re: Support for persistant objects in PostgreSQL?
Date
Msg-id 107B7CBF-E47D-11D8-AAAE-000D9366F0C4@torgo.978.org
Whole thread Raw
In response to Support for persistant objects in PostgreSQL?  (Suresh Tri <trisuresh@yahoo.co.in>)
List pgsql-hackers
On Aug 2, 2004, at 2:08 AM, Suresh Tri wrote:

> Hi,
>
> Can you have persistant objects in PostgreSQL? In
> Oracle you can have create Object types. e.g
> create type ADDRESS as object
>    (street_name     VARCHAR2(30),
>     house_no        NUMBER);
> In Oracle you can even have references to these
> objects from other tables.
>

create type ADDRESS as (street_name varchar(30),house_no int
);

should be about the same.

You can write stored proc's to return setof address if you want.
Not sure if there are other things that make oracle objects special.

There is even support for creating your own truely unique type where 
you need to write your inputter, outputter and comparison functions.  
That can allow you to natively support some proprietary data format you 
may have.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: why is postgres-R not in standard dev Path.
Next
From: Bruce Momjian
Date:
Subject: Re: SQL conformance docs