Postgres functions and Stored Procedures?

Поиск
Список
Период
Сортировка
От Kim Markle
Тема Postgres functions and Stored Procedures?
Дата
Msg-id 549B01194628D11184EF00805FA6DCBAF3C14A@CORP2
обсуждение исходный текст
Список pgsql-sql
I am new to Postgres and have researched the mail archives but I have
not found the answer for this (only questions).  I am very familiar with
using MS SQL 6.5 and have written tons of SP's.  The example below is
how one could write a SP for MS SQL which returns a record set.  My
question is how do I do this with Postgres functions?

create procedure ListAIS
as
select aisname as "AIS Name", aisdescription as "Description",
       username as "User Name", password as "Password" from ais_list
GO

GRANT  EXECUTE  ON dbo.EPRS_ListAIS  TO USER
GO

Thanks,

Kim Markle
Tivoli Kennels


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

Предыдущее
От: Larry Bottorff
Дата:
Сообщение: Re: [SQL] int4 to varchar conversion
Следующее
От: Christophe Labouisse
Дата:
Сообщение: Case insensitive equality operator