Re: Concatenating strings within a function definition

Nishad Prakash <prakashn@uci.edu> 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))'

            regards, tom lane