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@it.maidstone.gov.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.kromski@gaschka.pl]
Sent: Tuesday, August 22, 2000 12:47 PM
To: pgsql-interfaces@postgresql.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