| From: | Joe Maldonado <jmaldonado(at)webehosting(dot)biz> |
|---|---|
| To: | Patrick Nelson <pnelson(at)neatech(dot)com> |
| Cc: | PostgreSQL "List (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: RE in WHERE |
| Date: | 2002-10-10 19:31:16 |
| Message-ID: | 1034278277.5871.41.camel@mazu-joem.mazunetworks.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hunter Matthews | 2002-10-10 21:47:48 | Re: phpPgAdmin + PostgreSQL + authentication |
| Previous Message | Jeff Eckermann | 2002-10-10 19:30:58 | Re: RE in WHERE |