Re: [HACKERS] Object Oriented Features
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
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
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
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
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])