Re: [BUGS] Concatenating strings within a function definition

[Tom Lane]

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))'

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html