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.

Is persistant objects and references to these objects
supported in PostgreSQL? If so can anyone point me to
the documentation for these?

Thanks,
Suresh



	
	
		
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun!  http://uk.messenger.yahoo.com

Mon, 2 Aug 2004 07:08:35 +0100 (BST)
=?iso-8859-1?q?Suresh=20Tri?= <trisuresh@yahoo.co.in>
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@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/


Mon, 2 Aug 2004 08:11:20 -0400
Jeff <threshar@torgo.978.org>
Re: Support for persistant objects in PostgreSQL?