Re: opposite of chr(int) - Mailing list pgsql-novice

From Henry Drexler
Subject Re: opposite of chr(int)
Date
Msg-id CAAtgU9TC+4+dfgKe2dn5V+Co72vHGedV=FzNU1evwsJ8Th_cGA@mail.gmail.com
Whole thread Raw
In response to opposite of chr(int)  (Henry Drexler <alonup8tb@gmail.com>)
Responses Re: opposite of chr(int)  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-novice


On Thu, Oct 6, 2011 at 3:57 PM, Richard Broersma <richard.broersma@gmail.com> wrote:

SELECT 'wallawa9kl' ~ '^.{7}\d';

--
Regards,
Richard Broersma Jr.


Richard, could you tell me if I have interpreted your above expression correctly.


I believe this is saying
     ~ matches
     ^. starts with seven preceding characters
     \d represents a digit

So it is saying look past seven characters "^.{7}" and check that next character if it is an interger "\d"
Is that a correct narrative for what is going on?

pgsql-novice by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: opposite of chr(int)
Next
From: Richard Broersma
Date:
Subject: Re: opposite of chr(int)