Re: [HACKERS] Object Oriented Features

2002-06-27 Thread Karel Zak

On Thu, Jun 27, 2002 at 10:13:26AM +0530, Nishkala wrote:
 
 I am a student doing my graduation in India. I want to know what are the 
 other OODBMS features ( other than inheritance ) available 
 in PostGreSQL. It would be great if you can help me out with some 
 information regarding this.

 The PostgreSQL is Object-Relational DBMS and not clean Object Oriented.
 The good and short description about DBs types you can read at

http://wwwinfo.cern.ch/db/aboutdbs/classification/

 I think most of the current used SQL DBs are Object-Relational.
 

 OO in PostgreSQL means that you can create own operators, datetypes, functions...

 Something about really Object Oriented you can found at:

http://www.odbmsfacts.com/


Karel

-- 
 Karel Zak  [EMAIL PROTECTED]
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz



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

http://archives.postgresql.org





Re: [HACKERS] Object Oriented Features

2002-06-27 Thread Josh Berkus


Karel,

 
  OO in PostgreSQL means that you can create own operators, datetypes, 
functions...

Last I checked, all of these things were part of the SQL spec.   I believe our 
only OO functionality is inheritance ... which I have yet to find a use 
for.

Of course, I agree with Fabian Pascal, who claims that every OODBMS feature 
has an answer in the SQL spec that is more consistent and better thought out.

-- 
-Josh Berkus




---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])





Re: [HACKERS] Object Oriented Features

2002-06-27 Thread Christopher Clark

 Last I checked, all of these things were part of the SQL spec.   I believe
our
 only OO functionality is inheritance ... which I have yet to find a use
 for.

  Well, it's lower maintenance than the 14-clause SELECT...UNION...UNION...
I'd have to write for ``correct'' code, in my current project.  :-)

--
Christopher Clark [EMAIL PROTECTED]
Pongidae, and proud of it.

  Darn it, who spiked my coffee with water?
   -- Larry Wall





---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])





Re: [HACKERS] Object Oriented Features

2002-06-27 Thread Hannu Krosing

On Fri, 2002-06-28 at 03:21, Josh Berkus wrote:
 
 Karel,
 
  
   OO in PostgreSQL means that you can create own operators, datetypes, 
 functions...
 
 Last I checked, all of these things were part of the SQL spec.   I believe our 
 only OO functionality is inheritance ...

Actually _single_ inheritance is also part of SQL99 

create table ... under ...

 which I have yet to find a use for.

It will become much more useful once implemented more thoroughly ;)

---
Hannu




---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly





Re: [HACKERS] Object Oriented Features

2002-06-27 Thread Tatsuo Ishii

   OO in PostgreSQL means that you can create own operators, datetypes, 
 functions...
 
 Last I checked, all of these things were part of the SQL spec.   I believe our 
 only OO functionality is inheritance ... which I have yet to find a use 
 for.

Can you tell me what the SQL99 spec says regarding creation of
operators? I couldn't find them.
--
Tatsuo Ishii



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])