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