Alejandro Michelin Salomon ( Adinet ) wrote:
Hi :
I have installed Pg 8.08
I create this function :
CREATE OR REPLACE FUNCTION CALCULO_VALOR_LIQUIDO_HELPDESK( nTipoDesconto
SMALLINT,
nTipoComissao
SMALLINT,
When i test this functi
On Fri, Mar 03, 2006 at 11:06:20AM -0600, Eduardo Muñoz wrote:
> I'm new to pgSQL and I'm having some trouble with a
> function. I keep getting the following error:
>
> org.postgresql.util.PSQLException: ERROR: cursor
> "" does not exist
See my reply to your previous message about this:
http://a
On Thu, Mar 02, 2006 at 03:18:14PM -0600, Eduardo Muoz wrote:
> Hi, I'm new with pgSQL and I'm not sure why, but I
> keep getting the same error. I want to call a function
> that returns a cursor and I keep getting the following
> exception:
>
> org.postgresql.util.PSQLException: ERROR: cursor
> "
uom := (select uom from prodclass where code = prod_class) ;
Now I want to know why this syntax even compiles!?
What does this mean in plpgsql and where can I find a discussionin the
documentation?
Rick
Tom Lane wrote:
"Frank Millman" <[EMAIL PROTECTED]> writes:
uom := (select uo
On Mon, Apr 16, 2001 at 03:43:23PM +0200, DaVinci wrote:
> Hello.
>
> When I create next function:
>
> create function pilpot() returns integer as '
> declare
> foo integer;
> begin
> foo = insert into aviso(user) va