Timeline for answer to INSERT INTO postgres not working by juergen d
Current License: CC BY-SA 3.0
Post Revisions
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 20, 2015 at 13:13 | comment | added | Craig Ringer |
INSERT INTO ... SELECT ... WHERE is perfectly valid. The problem is that you cannot use a WHERE clause in a VALUES set-expression. That said, I agree that the user appears confused and seems to be trying to use INSERT to UPDATE a row.
|
|
| Aug 19, 2015 at 23:32 | history | answered | juergen d | CC BY-SA 3.0 |