question about reg. expression

From: andrew1 <andrew1(at)mytrashmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: question about reg. expression
Date: 2011-01-18 23:41:20
Message-ID: ih58f7$63u$1@speranza.aioe.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi all,

these return t:
select 'ab' ~ '[a-z]$'
select 'ab' ~ '^[a-z]'

select 'ab' ~ '^[a-z]$' returns f

Can't I use ^ and $ at the same time to match, in this case?
thanks.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Samuel Gendler 2011-01-19 10:21:07 Re: question about reg. expression
Previous Message Russell Galyon 2011-01-17 21:14:11 Re: Help needed in skipping column for copy command