Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8QJ9Th60270 for ; Wed, 26 Sep 2001 15:09:29 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 126144; Wed, 26 Sep 2001 12:09:22 -0700 From: "Josh Berkus" Subject: Re: Query does not work: parse ERROR, Re: How to enter lists into database: Problems with solution. To: Frederick Klauschen , Josh Berkus , pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Wed, 26 Sep 2001 12:09:22 -0700 Message-ID: In-Reply-To: <20010926184545.20714.qmail@web10108.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200109/231 X-Sequence-Number: 4913 Frederick, > I am really sorry to bother you again and I promise > to buy a book after this problem is solved and > stop asking these "beginners'" questions. Nah, this one wasn't a beginners question. Intermediate, maybe. > But the last example-Query you sent me does not > work, it produces: > > ERROR: parser: parse error at or near "(" Hmmm... I can't see anything wrong with the query. Unfortunately, I have not set up this test database myself, so I can't actually run it. Maybe someone else can spot the syntax error? I've looked it over again and there's nothing missing. Is it possible, Frederick, that the comma after "matches" or "people_attributes" got cut off? -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco