OO database?

[Socketd]

Hi all

I can see Postgresql calls itself a "object-relational database
management system", but what's the object part of it?

I have found inheritance, but are there more OO features in postgresql?

br
socketd (a postgresql newbie)

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Christopher Browne]

After a long battle with technology, [e-mail] (Socketd), an earthling, wrote:

Hi all

I can see Postgresql calls itself a "object-relational database
management system", but what's the object part of it?

I have found inheritance, but are there more OO features in postgresql?

It offers "method dispatch" where the system can invoke different
methods dependent on the types of values passed into a function.
--
select 'cbbrowne' || '@' || 'acm.org';
http://www3.sympatico.ca/cbbrowne/sgml.html
Q: What does the function NULL do?
A: The function NULL tests whether or not its argument is NIL or not. If
its argument is NIL the value of NULL is NIL.
-- Ken Tracton, Programmer's Guide to Lisp, page 73.

[Karel Zak]

On Tue, Dec 09, 2003 at 01:11:03AM +0100, Socketd wrote:

Hi all

I can see Postgresql calls itself a "object-relational database
management system", but what's the object part of it?

I have found inheritance, but are there more OO features in postgresql?

object-relational database != OO

The "object-relational" features are things like dynamic datatypes,
function, aggregation functions, user defined operators, etc.

http://wwwdb.web.cern.ch/wwwdb/aboutdbs/classification/

Karel

--
Karel Zak <za***@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)