No JOINs in UPDATE ... FROM?
От | Josh Berkus |
---|---|
Тема | No JOINs in UPDATE ... FROM? |
Дата | |
Msg-id | 3AE85E1E.2D39D02D@agliodbs.com обсуждение исходный текст |
Ответы |
random rows
Re: No JOINs in UPDATE ... FROM? |
Список | pgsql-sql |
Folks, In 7.1 RC2, I've been trying to use the following JOIN syntax: UPDATE assignments SET status = -1 FROM assignments JOIN orders ON assignments.order_usq = orders.usq WHERE orders.status = -1; However, I get an error of "Relation assignments referenced twice in query." Now, I can (and have) re-phrase the query so that PostgreSQL will accept it. However, I was under the impression that the above was standard SQL92. Am I mistaken? Or is this form something that just hasn't been implemented yet? -Josh -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
В списке pgsql-sql по дате отправления: