regular expressions troubles with char cols

From: dbahena(at)tpv(dot)com(dot)mx
To: pgsql-hackers(at)postgresql(dot)org
Subject: regular expressions troubles with char cols
Date: 2000-06-29 00:31:59
Message-ID: 200006290031.TAA11110@tpv.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi guys !!!!

Just a little question, I'd want to know, if the following situation is
a normal restriction(is should be strange..), or if it's a bug , or maybe
if I'm missing something ...

ventasge2000=# create table t1 (c1 char(10),c2 varchar(10));
CREATE
ventasge2000=# insert into t1 values('XXX666','XXX666');
INSERT 182218 1
ventasge2000=# select * from t1 where c1 ~ '666$';
c1 | c2
----+----
(0 rows)

ventasge2000=# select * from t1 where c2 ~ '666$';
c1 | c2
------------+--------
XXX666 | XXX666
(1 row)

Doesn't regular expressions(in particular the $ metachar) work properly
with char columns????

Thanks in advance

SEYA
Dario Estepario ...

PS: I'm using version 7.02, but I also see this trouble in 7.0

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-06-29 01:05:02 Re: Big 7.1 open items
Previous Message Hiroshi Inoue 2000-06-28 23:53:03 Re: Big 7.1 open items