Re: regular expressions in query - Mailing list pgsql-general

elein wrote:
> No doubt someone more adept at perl can write
> this function as a one-liner.
>
> create or replace function just_digits(text)
> returns text as
> $$
>         my $innum = $_[0];
>         $innum =~ s/\D//g;
>         return $innum;
> $$ language 'plperl'
>
>      SELECT telephone FROM addresses
>         WHERE user_id = 'bob'
>         AND just_digits(telephone) = '1115551212';
>
> --elein
>

I've  thought about things like this in the past, and a thought that
occurred to me was to add a functional index on just_digits(telephone)
to the table. Would this not allow the above query to use an index while
searching?

--

Russ.