Problem with LIKE in a SQL function

Поиск
Список
Период
Сортировка
От Mole
Тема Problem with LIKE in a SQL function
Дата
Msg-id E187dQH-0007a5-00@zebrahosts.net
обсуждение исходный текст
Ответы Re: Problem with LIKE in a SQL function
Re: Problem with LIKE in a SQL function
Список pgsql-novice
Hello,
    I have a bit of a problem, I have looked on the archives and didn't manage
to see anything.

I am trying to write the below function

mail_db=# CREATE FUNCTION "user_id_funct_p2"(varchar)
mail_db-# RETURNS setof varchar AS '
mail_db'# SELECT "mailbox" FROM "user" WHERE "mailbox" LIKE (\'$1%\') '
mail_db-# LANGUAGE sql ;
CREATE

mail_db=# select user_id_funct_p2('test');
 user_id_funct_p2
------------------
(0 rows)

If I  do
  SELECT "mailbox" FROM "user" WHERE "mailbox" LIKE ('test%') ;

It does returns the following results

 mailbox
----------
 test0001
 test0002
 test0003
 test0004
 test0005
 test0006
(6 rows)

If I ammed the function to return $1 it does return as test.  When I looked @
the debug output it seemed to be matching $1 rather that the value of $1.
That leads me to believe that my character escape sequence is incorrect.  I
have tried every possible combination but I am still not returning valid
results.

Many thanks in advance

Mole
--
==============
Caroline Fletcher
Head of Systems

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

Предыдущее
От: Scott Taylor
Дата:
Сообщение: PgAccess Visual Query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problem with LIKE in a SQL function