Re: [GENERAL] Problem with function parameters

2006-12-01 Thread Richard Huxton
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

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

2006-03-03 Thread Michael Fuhr
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

Re: [GENERAL] Problem with Function

2006-03-02 Thread Michael Fuhr
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 > "

Re: [GENERAL] Problem with function

2004-02-02 Thread Rich Hall
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

Re: [GENERAL] Problem with function invocation

2001-04-17 Thread will trillich
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