Re: Query does not work: parse ERROR, Re: How to enter lists into database: Problems with solution. - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Query does not work: parse ERROR, Re: How to enter lists into database: Problems with solution.
Date
Msg-id web-126144@davinci.ethosmedia.com
Whole thread Raw
In response to Query does not work: parse ERROR, Re: How to enter lists into database: Problems with solution.  (Frederick Klauschen <fklauschen@yahoo.com>)
List pgsql-sql
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
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: CHECK problem really OK now...
Next
From: Frederick Klauschen
Date:
Subject: PARSER ERROR