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
FROMsearch_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