Concatenating strings within a function definition

Поиск
Список
Период
Сортировка
От Nishad Prakash
Тема Concatenating strings within a function definition
Дата
Msg-id Pine.GSO.4.58.0411041109160.27376@e4e.oac.uci.edu
обсуждение исходный текст
Ответы Re: Concatenating strings within a function definition  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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 ilemma where lemma ~ (cast ''^'' as text) || upper ($1)'


but nothing works.  Can I do this at all?  The idea is that if $1 is
"foo", the query should be

    select lid from ilemma where lemma ~ '^FOO'

I'm running PostgreSQL 7.4 on sparc-sun-solaris2.8, compiled by GCC 3.0.4.

Thanks,

Nishad
--
"Underneath the concrete, the dream is still alive" -- Talking Heads

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: could not find /usr/local/timezone
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Concatenating strings within a function definition