Обсуждение: Inserting Information in PostgreSQL interval
Hey, I am having trouble entering intervals into a PostgreSQL inverval field. Currently I using prepared statements that look like this: {code} PreparedStatement query = conn.prepareStatement("INSERT............"); query.setObject(1, "{28.1, 29.2}"); query.setObject(2, "{1:23, 1:24}"); query.execute(); {code} And when I execute the code I get this error: org.postgresql.util.PSQLException: ERROR: column "field_1" is of type interval[] but expression is of type character varying So is there another way of entering an array of intervals into a postgresql database using prepared statement? What am I doing wrong? -- View this message in context: http://www.nabble.com/Inserting-Information-in-PostgreSQL-interval-tp24139349p24139349.html Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.
BlackMage wrote: > query.setObject(1, "{28.1, 29.2}"); > org.postgresql.util.PSQLException: ERROR: column "field_1" is of type > interval[] but expression is of type character varying The two-argument form of setObject() infers a type of Types.VARCHAR for a java.lang.String (see the JDBC spec) > So is there another way of entering an array of intervals into a postgresql > database using prepared statement? What am I doing wrong? Try: query.setObject(1, "{28.1, 29.2}", Types.OTHER); -O
Hey, that worked! Thanks a lot. BlackMage wrote: > > Hey, > > I am having trouble entering intervals into a PostgreSQL inverval field. > Currently I using prepared statements that look like this: > > {code} > > PreparedStatement query = conn.prepareStatement("INSERT............"); > query.setObject(1, "{28.1, 29.2}"); > query.setObject(2, "{1:23, 1:24}"); > query.execute(); > {code} > > And when I execute the code I get this error: > > org.postgresql.util.PSQLException: ERROR: column "field_1" is of type > interval[] but expression is of type character varying > > > So is there another way of entering an array of intervals into a > postgresql database using prepared statement? What am I doing wrong? > > -- View this message in context: http://www.nabble.com/Inserting-Information-in-PostgreSQL-interval-tp24139349p24140292.html Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.