On 24 Oct 2003, Manuel Sugawara wrote: > Matias Surdi <[EMAIL PROTECTED]> writes: > > > Manuel Sugawara wrote: > > >Use something like '^[a-z]{2}$' > > > > so, is this a bug???? > > No it is not. The sintax you are using is not supported.
It certainly seems to work in Postgresql 7.4 beta 4: create table test2 (info text); CREATE TABLE insert into test2 values ('ab'); INSERT 109169538 1 insert into test2 values ('abc'); INSERT 109169539 1 marl8412=# select * from test2 where info ~ '^[a-z]{2}$'; info ------ ab Or was there more to that message I wasn't getting? ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])