--- Patrick Nelson <pnelson@neatech.com> wrote:
> SELECT * FROM secure WHERE ~ '^12\.';
>
> displays
>
> host
> -----------------
> 12.28.18.10
> 12.41.17.174
> 128.121.247.126
> ...
>
> Escaping the dot should only show the 12. entries
> right? What is the proper
> RE for this?
>
Your statement goes through two rounds of parsing,
with escape characters being stripped off each time,
so your literal '.' is being interpreted as a
metacharacter. Try doubling your backslash escape.
__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com