Double up on the back slashes.
SELECT * FROM secure WHERE ~ '^12\\.'
Patrick Nelson 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?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster