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, importepago1 numeric, fechapago1 DATE, concepto1 character varying, tipopagonomina1 character varying, comentarios1 character varying) > RETURNS integer AS....implementation.... > > notice the field "fechapago1 DATE" > > the function is working just fine, I tried it from pgadmin3 and it works, > but when I try to call it using java's PreparedStatement pst; > pst.setDate(3, date); > I get this error, (note: "no existe la función" means "the function .... doesn't exists") > > org.postgresql.util.PSQLException: ERROR: no existe la función insertaegreso(integer, double precision, unknown, character varying, character varying, character varying) > > it puts "unknown" instead of date > > > is there a workaround for it that doesn't involve creating a function with VARCHAR instead of DATE? > > > because also when I try to do something like > > String sql1 = "SELECT EXTRACT (YEAR FROM ?)"; > PreparedStatement pst = con.getPreparedStatement(sql1); > pst.setDate(1, date); > > I get this error: > > (the function....isn't unique) > org.postgresql.util.PSQLException: ERROR: la función pg_catalog.date_part(unknown, unknown) no es única > > > tanks in advance > _________________________________________________________________ > Plug&Play te trae en exclusiva los mejores conciertos de la red > http://club.prodigymsn.com/ > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general _________________________________________________________________ Plug&Play te trae en exclusiva los mejores conciertos de la red http://club.prodigymsn.com/
