regular expressions troubles with char cols

Поиск
Список
Период
Сортировка
От dbahena@tpv.com.mx
Тема regular expressions troubles with char cols
Дата
Msg-id 200006290031.TAA11110@tpv.com.mx
обсуждение исходный текст
Ответы Re: regular expressions troubles with char cols
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Adam Walczykiewicz"
Дата:
Сообщение: SPI - documentation
Следующее
От: kuznet@ms2.inr.ac.ru
Дата:
Сообщение: Re: Fwd: Re: Fwd: Problem with recv syscall on socket when other side closed connection