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
On Wed, Mar 28, 2001 at 04:13:19PM -0800, Soma Interesting wrote:
> I have the following trigger/stored procedure:
>
> CREATE FUNCTION memb_num () RETURNS opaque AS '
> BEGIN
> NEW.member_num := date_part(''epoch'', timestamp ''now'');
