Re: opposite of chr(int)

From: Henry Drexler <alonup8tb(at)gmail(dot)com>
To: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: opposite of chr(int)
Date: 2011-10-06 21:49:06
Message-ID: CAAtgU9TC+4+dfgKe2dn5V+Co72vHGedV=FzNU1evwsJ8Th_cGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

>
> SELECT 'wallawa9kl' ~ '^.{7}\d';
>
> --
> Regards,
> Richard Broersma Jr.
>

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

Referencing
http://www.postgresql.org/docs/9.1/static/functions-matching.html

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?

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma 2011-10-07 15:15:38 Re: opposite of chr(int)
Previous Message Merlin Moncure 2011-10-06 21:23:29 Re: opposite of chr(int)