Mole <mole@zebra.co.uk> writes:
> 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 ;
I think you want:
SELECT "mailbox" FROM "user" WHERE "mailbox" LIKE ($1 || \'%\') '
regards, tom lane