Re: [GENERAL] issues with java driver setDate() on function call

2008-08-02 Thread Tom Lane
"Ismael " <[EMAIL PROTECTED]> writes: > I have a function declared as follows > CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importepago1 > numeric, fechapago1 DATE, concepto1 character varying, tipopagonomina1 > character varying, comentarios1 character varying) > RETURNS integ

Re: [GENERAL] issues with java driver setDate() on function call

2008-08-02 Thread Ismael ....
sorry, just discovered the answer, only need to cast the value like this String sql = "SELECT * FROM insertaEgreso(?, ?, ?::DATE, ?, ?, ?)"; pst.setDate(3, date); :) > > > I have a function declared as follows > CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importe

[GENERAL] issues with java driver setDate() on function call

2008-08-02 Thread Ismael ....
I have a function declared as follows CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importepago1 numeric, fechapago1 DATE, concepto1 character varying, tipopagonomina1 character varying, comentarios1 character varying) RETURNS integer ASimplementation notice the field "fech