* Mario Alberto Soto Cordones <mario_soto@compuall.cl> [20.03.2003 19:09]:
> Hi...
>
> i create a function in postgres to return a data of a table but when try
> to create say
>
> PostgreSQL ha dicho: ERROR: parser: parse error at or near "text"
> Your query:
>
> CREATE FUNCTION sinomemp(text)
> RETURNS text
> AS 'DECLARE sinomemp TEXT;
> BEGIN
> SELECT name
> FROM simaemp
> WHERE cod = $1;
> RETURN sinomemp;
> END;'
> LANGUAGE 'sql'
Actually, this question is for SQL list, not ADMIN.
You have `return' statement in your code, it is part of plpgsql language,
not sql.
So, changing last line to:
LANGUAGE plpgsql;
will solve your problem.
One note: it seems, that sinomemp variable is not in use.
May be this is what you need:
CREATE or replace FUNCTION sinomemp(text) RETURNS text AS '
SELECT name
FROM simaemp
WHERE cod = $1;'
LANGUAGE sql;
--
Victor Yegorov
