Create Stored procedure

From: Martin Paulďuro <martin(dot)paulduro(at)smeonline(dot)sk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Create Stored procedure
Date: 2003-03-11 12:53:48
Message-ID: 004d01c2e7cd$42708ee0$4c18010a@bitmedia.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Månsson 2003-03-11 13:10:16 commiting in/between functions
Previous Message jose antonio leo 2003-03-11 11:03:54 Re: unlock Select for update