Re: RE in WHERE - Mailing list pgsql-general

From Joe Maldonado
Subject Re: RE in WHERE
Date
Msg-id 1034278277.5871.41.camel@mazu-joem.mazunetworks.com
Whole thread Raw
In response to RE in WHERE  (Patrick Nelson <pnelson@neatech.com>)
List pgsql-general
try this...
    select * from secure where  ~'^12[.]';

Joe Maldonado
On Thu, 2002-10-10 at 15:13, 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



pgsql-general by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: RE in WHERE
Next
From: "Mihai Gheorghiu"
Date:
Subject: Age function