RE in WHERE

From: Patrick Nelson <pnelson(at)neatech(dot)com>
To: "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: RE in WHERE
Date: 2002-10-10 19:13:57
Message-ID: 4165C48DE9A0D211B6400800095C585F172E6C@WASHINGTON
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Luc Lachance 2002-10-10 19:27:31 Re: RE in WHERE
Previous Message Josh Burdick 2002-10-10 19:08:39 question about executing JOINs