agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: golder@informatik.uni-wuerzburg.de
To: postgres@postgres.Berkeley.EDU
Subject: Problem with regular expression search on text
Date: Thu, 09 Mar 95 17:24:34 +0100
Message-ID: <9503091624.AA07173@winx22.informatik.uni-wuerzburg.de> (raw)

Hi everyone,

I have some trouble with the operator '~' in usage with the built-in type 'text'.
Have a look at the following classes:

* retrieve (c1.all) \g

Query sent to backend is "retrieve (c1.all) "
-----------------------------
| id          | phone       |
-----------------------------
| 1           | 1111        |
-----------------------------
| 2           | 2222        |
-----------------------------
| 3           | 3333        |
-----------------------------

Go 
* retrieve (c2.all) \g

Query sent to backend is "retrieve (c2.all) "
-----------------------------
| id          | name        |
-----------------------------
| 1           | Tim         |
-----------------------------
| 2           | Jeff        |
-----------------------------
| 3           | Joe         |
-----------------------------

where c1.id, c1.phone and c2.id are of type int4 and c2.name is of type text.

Then the query

* retrieve (c1.all) where c1.id = c2.id and c2.name ~ "J" and c2.id = 3 \g

Query sent to backend is "retrieve (c1.all) where c1.id = c2.id and c2.name ~ "J" and 
c2.id = 3 "

returns:

FATAL: no response from backend: detected in PQexec

This error occurs on Postgres 4r2 on a DEC 3000 AXP 300LX under OSF/1 V3.0.
I also tried the above query on Postgres 4r1 on a DECstation 3100 under ULTRIX 4.3a
where everything worked fine.

Any idea what could be wrong?

Many thanks in advance,

St. Golder
golder@informatik.uni-wuerzburg.de


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/

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: postgres@postgres.berkeley.edu
  Cc: golder@informatik.uni-wuerzburg.de
  Subject: Re: Problem with regular expression search on text
  In-Reply-To: <9503091624.AA07173@winx22.informatik.uni-wuerzburg.de>

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

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