pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPARSER ERROR persists ....
2+ messages / 2 participants
[nested] [flat]
* PARSER ERROR persists ....
@ 2001-09-27 15:19 Frederick Klauschen <fklauschen@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Frederick Klauschen @ 2001-09-27 15:19 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PARSER ERROR persists ....
@ 2001-09-27 16:25 Tom Lane <tgl@sss.pgh.pa.us>
parent: Frederick Klauschen <fklauschen@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2001-09-27 16:25 UTC (permalink / raw)
To: Frederick Klauschen <fklauschen@yahoo.com>; +Cc: pgsql-sql
Frederick Klauschen <fklauschen@yahoo.com> writes:
> 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?
Actually, that's a red flag indicating that you did the wrong thing.
You may be running a 7.1.3 psql, but the server you are talking to
is not 7.1.*, but something older (try "select version()" to prove it).
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-09-27 16:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-09-27 15:19 PARSER ERROR persists .... Frederick Klauschen <fklauschen@yahoo.com>
2001-09-27 16:25 ` Tom Lane <tgl@sss.pgh.pa.us>
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