Re: substr_count

On Thu, 10 Jul 2003, Tom Rochester wrote:

> I would like to achive something along the lines of:
>
> SELECT field FROM table WHERE field ILIKE '$searchterm' ORDER BY
> substr_count(field, '$searchterm');

If you have plperl installed:

create or replace function substr_count(
varchar(255),
varchar(255)
)
returns int as '
my ($field, $searchterm) = @_;
my $count = $field =~ s/$searchterm//g;
return $count;
' language 'plperl';

michael