Re: How can i create an object in Postgres

From: Suraj Peri <suraj_peri(at)yahoo(dot)com>
To: "William N(dot) Zanatta" <william(at)veritel(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: How can i create an object in Postgres
Date: 2002-06-25 04:54:01
Message-ID: 20020625045401.4003.qmail@web10507.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Group,
Could you please tell me how to create an object in
postgreSQL. (i.e) like in oracle, can i do with this
syntax..

Create type <object_Name> as Object (.....);

I tried the above syntax in postgreSQL, it gives
parser error at "as"

How do we define the object in postgreSQL and also
hold it an array in the table.

Awaiting for earliest response

Thanks in advance..

Suraj

=====
PIL/BMB/SDU/DK

=====
PIL/BMB/SDU/DK

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Harry Yau 2002-06-25 05:36:11 Multiversion Concurrency Control!
Previous Message Bruce Momjian 2002-06-25 04:30:58 Re: Astonishing explain...!