Inserting Information in PostgreSQL interval

Поиск
Список
Период
Сортировка
Искать

Inserting Information in PostgreSQL interval

От:
BlackMage <dsd7872@uncw.edu>
Дата:

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.

Re: Inserting Information in PostgreSQL interval

От:
BlackMage <dsd7872@uncw.edu>
Дата:

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.

Re: Inserting Information in PostgreSQL interval

От:
Oliver Jowett <oliver@opencloud.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
FAQ