Re: tablename.columnname support

Поиск
Список
Период
Сортировка
От Jerome Slangen
Тема Re: tablename.columnname support
Дата
Msg-id 39C398F4.2CBA2566@exmachina.net
обсуждение исходный текст
Ответ на Re: tablename.columnname support  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-admin
The Hermit Hacker wrote:
>
> 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?

Just for the example:

As I do for simple web form dump to a database,
by finding the inputs related to earch table
using that prefix (sugar, doing this in Lua can
automatically create an associative array :).

- Jay

В списке pgsql-admin по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: tablename.columnname support
Следующее
От: "vijayendra mohan agrawal"
Дата:
Сообщение: FW: tablename.columnname support