Home > mailing lists

cast in JDBC update - Mailing list pgsql-jdbc

From	Tony Grant
Subject	cast in JDBC update
Date	August 7, 2001 10:46:50
Msg-id	997184349.3678.47.camel@tonux Whole thread Raw
Responses	Re: cast in JDBC update (Rene Pijlman <rpijlman@wanadoo.nl>)
List	pgsql-jdbc

Tree view

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

pgsql-jdbc by date:

From: Barry Lind
Date: 06 August 2001, 18:59:59
Subject: Re: Retrieving field of type bigint[]

From: Bryan Field-Elliot
Date: 07 August 2001, 13:16:22
Subject: PG Point and Circle data types, and JDBC?

cast in JDBC update - Mailing list pgsql-jdbc

Previous

Next