Postgreqsl & Package

Поиск

Список

Период

Сортировка

От	Birahim FALL
Тема	Postgreqsl & Package
Дата	22 октября 2003 г. 08:09:37
Msg-id	003201c3988d$356889c0$3e00a8c0@venus обсуждение исходный текст
Ответы	Re: Postgreqsl & Package RE : Postgreqsl & Package
Список	pgsql-general

Hi,

I was an oracle dev/admin and I'm quite new to postgresql.

Postgresql is great, but something bothers me.

It seems that there's no concept of PACKAGE in PL/pgSQL as in Oracle PL/SQL.

Is is definitely that? or did I missed something? or is it planned for a future version?

I've searched in the mailing lists archives, read many lines about schema / Package support in Postgresql,

but I'm still not able to concreately figure out if I can use packages.

In clear words, what I want to do is to group procedure and function in a way as

create package <package_name> as
    procedure p1 ......
    procedure p2 ....
    function f1 .....
    function f2 .....
end;

and the be able to do a

select * from a_table where package_name.f1(a_column) > 10;

Thanks for your answer.

Bir.

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