[GENERAL] Fwd: JDBC Array double precision [] error

2013-03-31 Thread Juan Pablo Cook
Hi everyone! I need your help with this problem. I'm using PostgreSQL 9.2 Server & the latest jdbc driver: postgresql-9.2-1002.jdbc4.jar I have a table with this column array: -- histograma double precision[] And I want to retrieve this and cast into java to double[] but I can't. This is the e

Re: [GENERAL] Fwd: JDBC Array double precision [] error

2013-03-31 Thread Juan Pablo Cook
Hi Hannes... Thanks a lot for your help! I was stuck being many many hours trying and googling it the problem but didn't realize that. This: *Double[] array = (Double[]) rs1.getArray("histograma").get**Array();* solve my problem! Thanks again!! Juan Cook On Sun, Mar 31, 2013 at 7:38 PM, Han

[GENERAL] Trigger of Transaction

2013-04-01 Thread Juan Pablo Cook
Hi everyone! I need your help with this problem. I'm using PostgreSQL *9.2 Server* & the latest jdbc driver: postgresql-9.2-1002.jdbc4.jar I have a many to one relation. I have this piece of code: con.setAutoCommit(false); //transaction block start // Make an insert to one table (Vector) // Aft

[GENERAL] Function Issue and casting

2009-07-04 Thread Juan Pablo Cook
Hi friends, It's my first time I'm writing to the list. All days I enjoy the list! I declare a function, and when I want to call this, it fails. My function: CREATE OR REPLACE FUNCTION alta_docente(integer,varchar,varchar,varchar,bigint,varchar,integer) RETURNS VOID AS $body$ declare codigo in

[GENERAL] Function Issue and casting

2009-07-04 Thread Juan Pablo Cook
Adrian, thanks a lot!!! for your quicky reply. Thats the error!, my casting was ok, but my schema path was wrong. I didn't realize that. Thanks a lot! Bye! On Sat, Jul 4, 2009 at 3:25 PM, Adrian Klaver wrote: > On Saturday 04 July 2009 10:47:34 am Juan Pablo Cook wrote: > > Hi

[GENERAL] LIKE problem

2009-07-05 Thread Juan Pablo Cook
Hi Everybody! I'm asking you, because recently I have some problems with the LIKE so I test with an easy and simple query but doesn't work: SELECT * FROM employee WHERE id like 'h%'; The error says: "ERROR: operator does not exist: integer ~~ unknown LINE 5: WHERE id like 'h%';