Re: [JDBC] cast in JDBC update

2001-08-07 Thread Rene Pijlman 

On 07 Aug 2001 13:39:09 +0200, you wrote:
>I am trying to update a field which contains an array of 
>type INT4 via JDBC.

Java source code? UPDATE statement? Table description?

Regards,
René Pijlman

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[JDBC] cast in JDBC update

2001-08-07 Thread Tony Grant 

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


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly