Frank Church wrote:
Does PostgreSQL support INSERT syntax of this kind -
insert into table (table.col1, table.col2, table.col3) values('one', 'two',
'three')?
Trying it out generates an error. It works when the 'table' bit is removed from
the column names.
What would this do for you? What would it mean if I wrote?
INSERT INTO table1 (table2.col1, table3.col2) VALUES (...)
The list of columns can only apply to the table you've just named -
that's the only thing that makes sense.
--
Richard Huxton
Archonet Ltd
