tablename.columnname support

From: "vijayendra mohan agrawal" <vijayendra(dot)agrawal(at)wipro(dot)com>
To: "PostGre SQL Mailing List" <pgsql-admin(at)postgresql(dot)org>
Subject: tablename.columnname support
Date: 2000-09-16 07:45:17
Message-ID: 004601c01fb2$0f6e4ae0$2a14a8c0@Protea.wipinfo.soft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

say, we have a table created by :
create table a ( a char(11), b char(22) );

For adding data into table 'a', ORACLE supports column name format as
tablename.columnname as follows :
insert into a ( a.a, a.b ) values ( 'xyz', 'abc') ;

But, PostGreSQL doesn't support... It gives parse error as follows :
ERROR: parser: parse error at or near "."

Can this feature be added in PostGreSQL ???

Thank You,
Best Regards,
Vijay

************************************************************
Vijayendra Mohan Agrawal
Wipro Technologies
26, Hosur Main Road, Bommanhalli,
Bangalore-560068, India
Tel: 91-80-5722296 Extn:3076
Fax: 91-80-5722696
E-mail : Vijayendra(dot)Agrawal(at)wipro(dot)com
**************************************************************

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message The Hermit Hacker 2000-09-16 15:20:08 Re: tablename.columnname support
Previous Message Mang Chan 2000-09-16 06:41:24 Compiling on DigitalUnix