Create Stored procedure - Mailing list pgsql-general

From Martin Paulďuro
Subject Create Stored procedure
Date
Msg-id 004d01c2e7cd$42708ee0$4c18010a@bitmedia.sk
Whole thread Raw
List pgsql-general
I can write stored procedure. My procedure in mssql is:

CREATE PROCEDURE sp_list AS
select id, name, phone, comment from user where (id>100) order by name
GO

How can I create this procedure in psql ?

Thanks. Matop.


pgsql-general by date:

Previous
From: "jose antonio leo"
Date:
Subject: Re: unlock Select for update
Next
From:
Date:
Subject: Re: mapping user name to group name