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 по дате отправления: