Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id IAA19429 for postgres-redist; Thu, 9 Mar 1995 08:25:06 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199503091625.IAA19429@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from wrzx01.rz.uni-wuerzburg.de (wrzx01.rz.uni-wuerzburg.de [132.187.1.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id IAA19414 for <postgres@postgres.berkeley.edu>; Thu, 9 Mar 1995 08:24:48 -0800
From: golder@informatik.uni-wuerzburg.de
Received: from winx22.informatik.uni-wuerzburg.de (wi2x22.informatik.uni-wuerzburg.de) by wrzx01.rz.uni-wuerzburg.de (4.1/uniwue-M-3.2)
	id AA04175; Thu, 9 Mar 95 17:24:38 +0100
Received: from localhost by winx22.informatik.uni-wuerzburg.de (5.65/uniwue-C-3.1)
	id AA07173; Thu, 9 Mar 1995 17:24:35 +0100
Message-Id: <9503091624.AA07173@winx22.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
Resent-To: postgres-redist@postgres.Berkeley.EDU
X-Mts: smtp
Resent-Date: Thu, 09 Mar 95 08:25:06 -0800
Resent-XMts: smtp

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/