what the problem with this query

IT appears you have one too many closing parans.

SELECT o.orgunitname AS ouname, e.entrynumber AS value_field, centroid

(

c.the_geom

) AS the_geom, c.ogc_fid AS ogc_fid FROM

(

ctrphc AS c INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname

) INNER JOIN

( SELECT orgunitid, entrynumber FROM routinedataou4 WHERE
dataelementid=1195 AND dataperiodid = 86

) AS e ON o.orgunitid = e.orgunitid

) AS new_table USING UNIQUE ogc_fid USING SRID=-1

_____

From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of venu gopal
Sent: Friday, April 14, 2006 5:09 AM
To: pgsql-admin@postgresql.org; pgsql-general@postgresql.org
Subject: [GENERAL] what the problem with this query

Hi all,
When i try to run the following query it gives the following error what
was wrong in the query.

Query:SELECT o.orgunitname AS ouname, e.entrynumber AS value_field,
centroid(c.the_geom) AS the_geom, c.ogc_fid AS ogc_fid FROM (ctrphc AS c
INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname) INNER JOIN (SELECT
orgunitid, entrynumber FROM routinedataou4 WHERE dataelementid=1195 AND
dataperiodid = 86) AS e ON o.orgunitid = e.orgunitid) AS new_table USING
UNIQUE ogc_fid USING SRID=-1

Error::ERROR: syntax error at or near ")" at character 333

Regards,
venu

o.orgunitid = e.orgunitid)

That ")" is not valid Venu. (Nothing is being enclosed)

Regards,
Guido

On 4/14/06, venu gopal <gopalonline2@yahoo.co.uk> wrote:

Hi all,
When i try to run the following query it gives the following error what
was wrong in the query.

Query:SELECT o.orgunitname AS ouname, e.entrynumber AS value_field,
centroid(c.the_geom) AS the_geom, c.ogc_fid AS ogc_fid FROM (ctrphc AS c
INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname) INNER JOIN (SELECT
orgunitid, entrynumber FROM routinedataou4 WHERE dataelementid=1195 AND
dataperiodid = 86) AS e ON o.orgunitid = e.orgunitid) AS new_table USING
UNIQUE ogc_fid USING SRID=-1

Error::ERROR: syntax error at or near ")" at character 333

Regards,
venu

--
Guido Barosio
-----------------------
http://www.globant.com
guido.barosio@globant.com

On Apr 14, 2006, at 20:09 , venu gopal wrote:

Query:SELECT o.orgunitname AS ouname, e.entrynumber AS value_field,
centroid(c.the_geom) AS the_geom, c.ogc_fid AS ogc_fid FROM (ctrphc
AS c INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname) INNER
JOIN (SELECT orgunitid, entrynumber FROM routinedataou4 WHERE
dataelementid=1195 AND dataperiodid = 86) AS e ON o.orgunitid =
e.orgunitid) AS new_table USING UNIQUE ogc_fid USING SRID=-1

Error::ERROR: syntax error at or near ")" at character 333

[please don't post HTML]

I'm not familiar with the syntax you're using, but one problem is
that your parentheses are not balanced -- there's an extra closing
parenthesis. That's probably what the error is complaining about. You
might want to try to use whitespace to see the structure of your
query better, e.g.,

SELECT o.orgunitname AS ouname
, e.entrynumber AS value_field
, centroid(c.the_geom) AS the_geom
, c.ogc_fid AS ogc_fid
FROM (
ctrphc AS c
INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname)
INNER JOIN (
SELECT orgunitid
, entrynumber
FROM routinedataou4
WHERE dataelementid=1195
AND dataperiodid = 86
) AS e ON o.orgunitid = e.orgunitid) AS new_table USING UNIQUE
ogc_fid USING SRID=-1

Hope this helps a bit.

Michael Glaesemann
grzm myrealbox com

Michael Glaesemann <grzm@myrealbox.com> writes:

I'm not familiar with the syntax you're using, but one problem is
that your parentheses are not balanced -- there's an extra closing
parenthesis. That's probably what the error is complaining about. You
might want to try to use whitespace to see the structure of your
query better, e.g.,

Also, consider using a newer Postgres release. 8.0 and up provide
a cursor pointer so that you don't have to count characters:

regression=# SELECT o.orgunitname AS ouname, e.entrynumber AS value_field, centroid(c.the_geom) AS the_geom, c.ogc_fid AS ogc_fid FROM (ctrphc AS c INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname) INNER JOIN (SELECT orgunitid, entrynumber FROM routinedataou4 WHERE dataelementid=1195 AND dataperiodid = 86) AS e ON o.orgunitid = e.orgunitid) AS new_table USING UNIQUE ogc_fid USING SRID=-1;
ERROR: syntax error at or near ")" at character 333
LINE 1: ...taperiodid = 86) AS e ON o.orgunitid = e.orgunitid) AS new_t...
^
regression=#

regards, tom lane

On Fri, Apr 14, 2006 at 11:09:16AM +0000, venu gopal wrote:

Hi all,
When i try to run the following query it gives the following error what was wrong in the query.

Query:SELECT o.orgunitname AS ouname, e.entrynumber AS value_field, centroid(c.the_geom) AS the_geom, c.ogc_fid AS ogc_fid FROM (ctrphc AS c INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname) INNER JOIN (SELECT orgunitid, entrynumber FROM routinedataou4 WHERE dataelementid=1195 AND dataperiodid = 86) AS e ON o.orgunitid = e.orgunitid) AS new_table USING UNIQUE ogc_fid USING SRID=-1

Error::ERROR: syntax error at or near ")" at character 333

Extra ) after the the last ON.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461