X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 006B811F696D for ; Fri, 14 Apr 2006 08:09:24 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.4 X-Spam-Level: X-Spam-Status: No, score=0.4 required=5 tests=[AWL=-0.080, DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id oPwGdXKgR25j for ; Fri, 14 Apr 2006 08:09:17 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web25608.mail.ukl.yahoo.com (web25608.mail.ukl.yahoo.com [217.12.10.167]) by postgresql.org (Postfix) with SMTP id 4C05E11F694D for ; Fri, 14 Apr 2006 08:09:19 -0300 (ADT) Received: (qmail 9273 invoked by uid 60001); 14 Apr 2006 11:09:16 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=Iak0lHaQPyBqTq1TPPU8I2VspCukkmXYN9X3VH28wnjuTGgn61lMSSqqpPOg4SbTQsmUIPRjnyExUg+jp7TH7qAZUJzbA27/1WHdKxq5yDFmdjFK6ONRfnKgKfDIDHXBZwKkYjCNTJq63Gqycco2qS8UCwRdwoUxJlkZFo/smxI= ; Message-ID: <20060414110916.9271.qmail@web25608.mail.ukl.yahoo.com> Date: Fri, 14 Apr 2006 11:09:16 +0000 (GMT) From: venu gopal Reply-To: venu gopal Subject: what the problem with this query To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1417743388-1145012956=:9003" X-Archive-Number: 200604/125 X-Sequence-Number: 21294 --0-1417743388-1145012956=:9003 Content-Type: text/plain; charset=us-ascii 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 --0-1417743388-1145012956=:9003 Content-Type: text/html; charset=us-ascii
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

--0-1417743388-1145012956=:9003--