Re: [SQL] Object-relational features

2004-03-15 Thread Stephan Szabo
On Sat, 13 Mar 2004, Yasir Malik wrote: > For my object-relational database class I decided to use PostgreSQL > because it is my favorite database and it calls it self a ORDBMS. Little > did I know that it supports supports very little OR features. For > example, using "create type as" is totall

Re: [SQL] Object-relational features

2004-03-15 Thread Yasir Malik
Dr. DeSoi Thanks for your reply. What is an "immutable strict" and what is an "internal" language? Does Postgres plan on implenting types as Oracle does? For example: create type AddrType as (street char(20), city char(20), zip char(5)); create type CustType as (name varchar(2), addr AddrType); c

Re: [SQL] Object-relational features

2004-03-15 Thread John DeSoi
On Mar 13, 2004, at 12:30 PM, Yasir Malik wrote: For example, using "create type as" is totally worthless because you can't use it as a field type in a table; you can't compose in another "create type as"; and you can't inherit another composite type. The only way to create a true type is to u

Re: [SQL] Invalid Characters

2004-03-15 Thread Paul Thomas
On 15/03/2004 10:37 Raman wrote: Hi All, I have imported some data from csv files in my DB. Now that data has some invalid characters stored in it. so I get this exception: Exception in ChannelDAO Invalid character data was found. This is most likely caused by stored data containing characters th