pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frederick Klauschen <fklauschen@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: PARSER ERROR persists ....
Date: Thu, 27 Sep 2001 08:19:38 -0700 (PDT)
Message-ID: <20010927151938.92143.qmail@web10108.mail.yahoo.com> (raw)

Hi,

I have tried Carl's suggestion, but it does
not make a difference and the same
ERROR: parser: parse error at or near "("
results.
I have rebuilt and reinstalled Version 7.1.3,
but still the same. No compilation or installation
errors are reported and simple statements seem
to work properly. In contrast to 7.0.3, the \d <table>
command does not work because 'format_type(oid,int4)'
does not exist, but this 
probably has nothing to do with my problem?
I am running SuSE Linux 7.2 (kernel 2.4.4).
Might any libraries not be loaded or could there
be any other problem related to installation?

Thanks, Frederick


Here is Josh's statement with Carl's modification:

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
         GROUP BY people_id) 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;



__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com



view thread (2+ messages)  latest in thread

Message-ID: <20010927151938.92143.qmail@web10108.mail.yahoo.com>
Permalink:  ../20010927151938.92143.qmail@web10108.mail.yahoo.com/
Also on:    postgresql.org/message-id/20010927151938.92143.qmail@web10108.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: fklauschen@yahoo.com
  Subject: Re: PARSER ERROR persists ....
  In-Reply-To: <20010927151938.92143.qmail@web10108.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox