cast in JDBC update

From: Tony Grant <tony(at)animaproductions(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: cast in JDBC update
Date: 2001-08-07 11:39:09
Message-ID: 997184349.3678.47.camel@tonux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

hello,

I am trying to update a field which contains an array of type INT4 via
JDBC.

ERROR: Attribute 'filmid' is of type '_int4' but expression is of type
'int4'
You will need to rewrite or cast the expression

How do I cast the expression in an JDBC update statement? The code used
is lovingly hand written by UltraDev... =:-D

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bryan Field-Elliot 2001-08-07 14:27:43 PG Point and Circle data types, and JDBC?
Previous Message Barry Lind 2001-08-07 02:04:24 Re: field of type oid