On Mar 29, 2011, at 10:18 AM, hook wrote:
> I have a simple table with a varchar(32) field that I am trying to extract
> data using regular expressions.
>
> select * from spam where inetaddr like '100.%'
> row | inetaddr | tdate
> --+--+-
On Tue, Mar 29, 2011 at 10:18 AM, hook wrote:
> What am I doing wrong???
>
You are confusing regular expressions with SQL "LIKE". Ie, you are
using "LIKE" and expecting it to match some odd notion of regexp.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
I have a simple table with a varchar(32) field that I am trying to
extract data using regular expressions.
select * from spam where inetaddr like '100.%'
row | inetaddr | tdate
--+--+---
3245 | 100.81.98.51 | 03/08/2011 07:21:19.2
