| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | vijayendra mohan agrawal <vijayendra(dot)agrawal(at)wipro(dot)com> |
| Cc: | PostGre SQL Mailing List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: tablename.columnname support |
| Date: | 2000-09-16 15:20:08 |
| Message-ID: | Pine.BSF.4.21.0009161219340.57014-100000@thelab.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, 16 Sep 2000, vijayendra mohan agrawal wrote:
> 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 ???
stupid question, but why would you use that format instead of doing:
INSERT INTO a ( a, b ) VALUES ( 'xyz', 'abc' );
Why the tablename. in front?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerome Slangen | 2000-09-16 15:59:48 | Re: tablename.columnname support |
| Previous Message | vijayendra mohan agrawal | 2000-09-16 07:45:17 | tablename.columnname support |