Folks,
Perhaps I've misunderstood this, but in PostgreSQL 8.3.5, I get
disparate results from ~ and SIMILAR TO. For example:
This gives an unexpected result:
davidfetter@davidfetter=# SELECT 'abc' SIMILAR TO '^[a]';?column?
----------f
(1 row)
This one is what I expected.
davidfetter@davidfetter=# SELECT 'abc' ~ '^[a]';?column?
----------t
(1 row)
Did I misunderstand what SIMILAR TO does, or...?
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate