Re: Mystery function error

Richard Sydney-Smith wrote:
> CREATE OR REPLACE FUNCTION public.locate(bpchar, bpchar) RETURNS
> int4 AS ' -- search for the position of $2 in $1
>
> declare srcstr alias for $1; searchstr alias for $2;
>
> begin return position(searchstr in srcstr); ' LANGUAGE 'plpgsql'
> VOLATILE;

You are missing the "end" keyword in there. Also, I'd think this
function is IMMUTABLE not VOLATILE.

CREATE OR REPLACE FUNCTION public.locate(bpchar, bpchar)
RETURNS int4 AS '
-- search for the position of $2 in $1
declare
srcstr alias for $1;
searchstr alias for $2;
begin
return position(searchstr in srcstr);
end;
' LANGUAGE 'plpgsql' IMMUTABLE;

This could also be done as:

CREATE OR REPLACE FUNCTION public.locate(bpchar, bpchar)
RETURNS int4 AS '
select position($2 in $1)
' LANGUAGE 'sql';

HTH,

Joe