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
**************************************************************
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 |