Re: Stored Procedure Problem

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: atul(at)imcindia(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Stored Procedure Problem
Date: 2002-12-12 13:37:33
Message-ID: 3DF8911D.DAFAEF09@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> CREATE FUNCTION b_function() RETURNS int4 AS '
> DECLARE
> an_integer int4;
> BEGIN
> select emp_id from employee;
> return an_integer;
> END;
> '
> LANGUAGE 'plpgsql';
>
Try
SELECT INTO an_integer emp_id from employee;

Regards, Christoph

Browse pgsql-sql by date

  From Date Subject
Next Message Atul 2002-12-12 13:41:36 Stored Procedure Problem
Previous Message Héctor Iturre 2002-12-12 12:56:15 Performance Problems