syntax error on WHERE clause...
От | Robert Poor |
---|---|
Тема | syntax error on WHERE clause... |
Дата | |
Msg-id | AANLkTinwUCkG5O64=V5xUj1UedCE0_XJeqv1SoXB40ST@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: syntax error on WHERE clause...
|
Список | pgsql-novice |
I'm getting syntax errors in what (I thought) is a simple query. This query works in SQLite, but in psql 8.3.14 gets: ERROR: syntax error at or near "WHERE" Here's the query: SELECT (d4.digit * 10000 + d3.digit * 1000 + d2.digit * 100 + d1.digit * 10 + d0.digit) AS date FROM digits AS d0 INNER JOIN digits AS d1 INNER JOIN digits AS d2 INNER JOIN digits AS d3 INNER JOIN digits AS d4 WHERE (d4.digit * 10000 + d3.digit * 1000 + d2.digit * 100 + d1.digit * 10 + d0.digit) < 33 ORDER BY date; Any idea what's wrong? FWIW, Digits is a table populated with 10 digits: => select * from digits; id | digit ----+------- 1 | 0 2 | 1 3 | 2 4 | 3 5 | 4 6 | 5 7 | 6 8 | 7 9 | 8 10 | 9 (10 rows) I'm sure it's something obvious, but reading http://www.postgresql.org/docs/8.3/interactive/queries-table-expressions.html has yet to lead me to enlightenment.
В списке pgsql-novice по дате отправления: