Re: Stored Procedure - Mailing list pgsql-general

From Nils Zonneveld
Subject Re: Stored Procedure
Date
Msg-id 3B121F51.6A35FDC0@mbit.nl
Whole thread Raw
In response to Stored Procedure  (Kémeri Lajos <lkemeri@metalogic.hu>)
List pgsql-general

KÈmeri Lajos wrote:

> And I call it: select * from LOGIN ('username', 'password');
> Result: 1, 'Lewis'
>

In PostgreSQL you can define only functions, they go a long way, but are
not really stored procedures. A stored procedure can return a tuple just
like you show. A function can only return one value.

Nils

pgsql-general by date:

Previous
From: "Madness"
Date:
Subject: altering data type in a column
Next
From: "Richard Huxton"
Date:
Subject: FW: arrays in oracle?