Re: PROBLEM WITH FUNCTIONS IN POSTGRES

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: PROBLEM WITH FUNCTIONS IN POSTGRES
Дата
Msg-id 20030320172242.GA20481@pirmabanka.lv
обсуждение исходный текст
Ответ на PROBLEM WITH FUNCTIONS IN POSTGRES  ("Mario Alberto Soto Cordones" <mario_soto@compuall.cl>)
Список pgsql-admin
* 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

Вложения

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

Предыдущее
От: "Mario Alberto Soto Cordones"
Дата:
Сообщение: PROBLEM WITH FUNCTIONS IN POSTGRES
Следующее
От: Andrew Biagioni
Дата:
Сообщение: Re: Performance problems with Postgresql