Received: from web10108.mail.yahoo.com (web10108.mail.yahoo.com [216.136.130.58]) by postgresql.org (8.11.3/8.11.4) with SMTP id f8QKO8h77785 for ; Wed, 26 Sep 2001 16:24:08 -0400 (EDT) (envelope-from fklauschen@yahoo.com) Message-ID: <20010926202403.39030.qmail@web10108.mail.yahoo.com> Received: from [128.231.231.124] by web10108.mail.yahoo.com via HTTP; Wed, 26 Sep 2001 13:24:03 PDT Date: Wed, 26 Sep 2001 13:24:03 -0700 (PDT) From: Frederick Klauschen Subject: PARSER ERROR To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200109/232 X-Sequence-Number: 4914 The commas did not get cut off and I think I did not make any other mistakes either. Is it also possible that the parser does not work properly? Thanks, Frederick Here is what happened again: ERROR: parser: parse error at or near "(" when running : > SELECT people.people_id, people.name, > people.address, > people_attributes.attribute_name, > people_attributes.attribute_value > FROM people, people_attributes, > ( SELECT people_id, count(*) as match_count > FROM people_attributes, search_attributes > WHERE search_id = 31 > AND people_attributes.attribute_name = > search_attributes.attribute_name > AND people_attributes.attribute_value ~* > search_attributes.attribute_value ) > matches, > ( SELECT count(*) as attribute_count > FROM search_attributes > WHERE search_id = 31 ) searched > WHERE people.people_id = people_attributes.people_id > AND people.people_id = matches.people_id > AND matches.match_count = > searched.attribute_count; Postgresql Verson 7.0.3 and 7.1.3. __________________________________________________ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com