Обсуждение: [DOCS] store procedure

Поиск
Список
Период
Сортировка

[DOCS] store procedure

От
manish.kumar@tamarindservices.com
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/plpgsql.html
Description:

hello ,I am new to the postgreSql , so i just want to know is it possible to
write a store procedure in postgresql such as mysql. if yes then how .please
suggest me with better answer.

Re: [DOCS] store procedure

От
Peter Eisentraut
Дата:
On 6/16/17 04:52, manish.kumar@tamarindservices.com wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/plpgsql.html
> Description:
>
> hello ,I am new to the postgreSql , so i just want to know is it possible to
> write a store procedure in postgresql such as mysql. if yes then how .please
> suggest me with better answer.

PostgreSQL does not have CREATE PROCEDURE, only CREATE FUNCTION.
However, there might be other differences if you are coming from a
different system.

This is not the right mailing list for this question.  See pgsql-general
or pgsql-novice please.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services