Re: [GENERAL] Determining if "in a text set" - Mailing list pgsql-sql

From Richi Plana
Subject Re: [GENERAL] Determining if "in a text set"
Date
Msg-id Pine.LNX.4.04.9903290235290.5417-100000@jaguar.mozcom.com
Whole thread Raw
In response to Re: [GENERAL] Determining if "in a text set"  (Herouth Maoz <herouth@oumail.openu.ac.il>)
Responses Re: [SQL] Re: [GENERAL] Determining if "in a text set"
Re: [GENERAL] Determining if "in a text set"
List pgsql-sql
Hi,

On Sun, 28 Mar 1999, Herouth Maoz wrote:

|o| perl's concept of word boundaries. But if the phrase is supposed to contain
|o| just spaces (ascii 32, if you will) as word separators, I'd match against
|o| the field with a space on the left and nothing on the right, a space on the
|o| right and nothing on the left, spaces on both sides, or standing alone:
|o| 
|o|   SELECT * FROM {class}
|o|   WHERE '{phrase}' ~ ' ' || ( rtrim( FieldN ) || '$' )
|o|      OR '{phrase}' ~ '^' || ( rtrim( FieldN ) || ' ' )
|o|      OR '{phrase}' ~ ' ' || ( rtrim( FieldN ) || ' ' )
|o|      OR '{phrase}' = rtrim( FieldN );

1) I'm not sure the regex thing is ANSI SQL and would port to other SQL
systems easilly
2) Isn't there a way to do [^{ws}](word)[{ws}$], where [^{ws}] means
either the start or a whitespace and [{ws}$] means either a whitespace or
EOL?
3) When I try the concat strings operator (||), I get the following psql
error:

ERROR:  parser: syntax error at or near "||"

What am I doing wrong? (I'm using PostgreSQL 6.4.2 on Sparc/Solaris with
GCC compiler) There's something wrong with the concat operator on my
system. I get diff. results from the ff. commands:

SELECT * FROM {class} where 'MON' = FieldN; and
SELECT * FROM {class} where 'MO' || 'N' = fieldN;

Anybody have a clue.


L   L Richi Plana 8^)         ,-,-.     ,-,-.     ,-,-.     ,-,-.     ,-
LL LL Systems Administrator  / / \ \   / / \ \   / / \ \   / / \ \   / /
LLLLL Mosaic Communications, Inc. \ \ / /   \ \ / /   \ \ / /   \ \ / / 
LLLLL mailto:richip@mozcom.com     `-'-'     `-'-'     `-'-'     `-'-'  
------------------------------------------------------------------------
P G P Key available at http://www2.mozcom.com/~richip/richip.asc
Tired of Spam? Join this CAUCE! http://www.cauce.org/



pgsql-sql by date:

Previous
From: Richi Plana
Date:
Subject: Re: [SQL] Re: [GENERAL] Determining if "in a text set"
Next
From: Richi Plana
Date:
Subject: Re: [SQL] Re: [GENERAL] Determining if "in a text set"