Postgres Pro
Downloads
Home   >   mailing lists

RE in WHERE - Mailing list pgsql-general

From Patrick Nelson
Subject RE in WHERE
Date
Msg-id 4165C48DE9A0D211B6400800095C585F172E6C@WASHINGTON
Whole thread Raw
Responses Re: RE in WHERE  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Re: RE in WHERE  (Joe Maldonado <jmaldonado@webehosting.biz>)
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Josh Burdick
Date:
Subject: question about executing JOINs
Next
From: Jean-Luc Lachance
Date:
Subject: Re: RE in WHERE