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.