Re: Support for persistant objects in PostgreSQL?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: trisuresh(at)yahoo(dot)co(dot)in
Subject: Re: Support for persistant objects in PostgreSQL?
Date: 2004-08-02 16:34:08
Message-ID: 200408020934.08679.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Suresh,

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

These structures are usually known as "Composite Types", although they have a
different, less intuitive name in the SQL99 standard which escapes me at the
moment. "Persistant Objects" is an Oracle-ism which is why you're having
trouble finding help on it.

Currently 7.4 PostgreSQL 7.4 supports the creation of such types and use of
them in Functions and queries. However, using them as a table column will
not be supported until the next PostgreSQL version, coming soon.

I don't reccomend using them at any time, though ...

--
Josh Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2004-08-02 17:18:26 Re: Support for persistant objects in PostgreSQL?
Previous Message Tom Lane 2004-08-02 16:27:28 Re: replication modules on postgres