Re: Support for persistant objects in PostgreSQL?

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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/