RES: [GENERAL] Problem with function parameters

Richard Huxton wrote: -->-Mensagem original- -->De: Richard Huxton [mailto:[EMAIL PROTECTED] -->Enviada em: sexta-feira, 1 de dezembro de 2006 12:24 -->Para: Alejandro Michelin Salomon ( Adinet ) -->Cc: Pgsql-General -->Assunto: Re: [GENERAL] Problem with f

Re: [GENERAL] Problem with function parameters

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

[GENERAL] Problem with function parameters

Hi : I have installed Pg 8.08 I create this function : CREATE OR REPLACE FUNCTION CALCULO_VALOR_LIQUIDO_HELPDESK( nTipoDesconto SMALLINT, nTipoComissao SMALLINT, nDesconto NUMER

Re: [GENERAL] Problem with function that returns a cursor

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

[GENERAL] Problem with function that returns a cursor

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 This is the function: CREATE OR REPLACE FUNCTION ret_user(pusername "varchar") RETURNS refcursor AS $BODY$ DECLARE ccursor re

Re: [GENERAL] Problem with Function

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 > "

[GENERAL] Problem with Function

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 "" does not exist I would appreciate any help with this problem. This is my

Re: [GENERAL] Problem with function

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

[GENERAL] problem with function to report how many records were changed

Hi, I intend to get some answer from postgres concerning if an update command has altered some records in the database. To do this I coded this function: create or replace function upd_ok(text,text,text,text) returns integer as ' declare table alias for $1; field alias fo

Re: [GENERAL] Problem with function invocation

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

[GENERAL] Problem with function invocation

Hello. When I create next function: create function pilpot() returns integer as ' declare foo integer; begin foo = insert into aviso(user) values(1); return foo; end;