RE: JDBC problem

The parser error is from the backend not JDBC (as it doesnt parse anything
other than PreparedStatement's).

I think it's the sub-select that's causing the problem, as it's not
supported in 6.5.

Peter

--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount(at)it(dot)maidstone(dot)gov(dot)uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council

-----Original Message-----
From: BogdanKRomski [mailto:b(dot)kromski(at)gaschka(dot)pl]
Sent: Tuesday, August 22, 2000 12:47 PM
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [INTERFACES] JDBC problem

Hello

I'm using the Postgresql 6.5 and i try to perform statement

INSERT into KEY_ITEM (key_item_id,keyName) values(((SELECT
MAX(key_item_id) FROM KEY_ITEM)+1),?)

and I get the message :

Error: ERROR: parser: parse error at or near "select"

I'm not sure but part "(SELECT MAX(key_item_id) FROM KEY_ITEM)+1)" of
statement does't work

thanks for all informations

Bogdan Kromski

ps. on Oracle and Sybase it is working correct