Nishad Prakash <[EMAIL PROTECTED]> writes:
> I'm trying to create a function like so:
> create function get_lid_prefix (text) returns setof int as
> 'select lid from ilemma where lemma ~ \'^\' + upper($1)'
> language 'sql';
'select lid from ilemma where lemma ~ (\'^\' || upper($1))'
I'm trying to create a function like so:
create function get_lid_prefix (text) returns setof int as
'select lid from ilemma where lemma ~ \'^\' + upper($1)'
language 'sql';
I've tried several variations, including
'select lid from ilemma where lemma ~ ' || '^' || ' upper ($1)'
'select lid from
