plpgsql test function
| От | kurt miller |
|---|---|
| Тема | plpgsql test function |
| Дата | |
| Msg-id | 20000711162047.73309.qmail@hotmail.com обсуждение исходный текст |
| Ответы |
Re: plpgsql test function
|
| Список | pgsql-general |
This simple test function fails.
----------------------------------------------
drop function testit(text);
create function testit(text) returns text as '
DECLARE
myval text;
BEGIN
myval:= $1;
return myval;
END;
' language 'plpgsql';
select testit('testing');
select testit(''testing'');
----------------------------------------------
Result:
DROP
CREATE
ERROR: parser: parse error at or near ""
ERROR: parser: parse error at or near "testing"
It doesn't seem like the parameter passing mechanism is working.
What am i missing?
TIA,
-km
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
В списке pgsql-general по дате отправления: