Skip site navigation (1) Skip section navigation (2)

syntax error on WHERE clause...

From: Robert Poor <rdpoor(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: syntax error on WHERE clause...
Date: 2011-03-15 23:44:18
Message-ID: AANLkTinwUCkG5O64=V5xUj1UedCE0_XJeqv1SoXB40ST@mail.gmail.com (view raw or flat)
Thread:
Lists: 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.

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2011-03-16 00:15:31
Subject: Re: syntax error on WHERE clause...
Previous:From: Chetan SuttrawayDate: 2011-03-15 06:05:57
Subject: Re: help regarding function valatality categories

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group