[SQL] Help with Array

2007-01-08 Thread Jeremiah Elliott
I have a java application that moves data from our erp platform (progress) into a Postgres database. One of the fields in progress is a character array. I haven't had any luck getting this field to transfer. What I would like to do is something like: preparedStatement.setArray(i,resultSet.ge

[SQL] avg(interval)

2006-06-26 Thread Jeremiah Elliott
ot;*2420" "3 days 06:05:59.456947";"*2420" which should average to just over nine days - Assuming I am not missing something huge here. I tend to think its a bug in avg(interval) postgres function. I am running postgres 8.1.3 on 32bit suse Thanks Jeremiah Elliott ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq