Received: from stone.gaschka.pl (root@pb74.zgora.sdi.tpnet.pl [213.25.236.74])
	by hub.org (8.10.1/8.10.1) with ESMTP id e7MBjgT91684
	for <pgsql-interfaces@postgresql.org>;
	Tue, 22 Aug 2000 07:45:43 -0400 (EDT)
Received: from gaschka.pl (bogdan.gaschka.pl [192.168.200.20])
	by stone.gaschka.pl (8.9.3/8.9.3/SuSE Linux 8.9.3-0.1) with ESMTP id
	NAA20031
	for <pgsql-interfaces@postgresql.org>; Tue, 22 Aug 2000 13:46:50 +0200
Message-ID: <39A2681C.4F34EE10@gaschka.pl>
Date: Tue, 22 Aug 2000 13:46:36 +0200
From: BogdanKRomski <b.kromski@gaschka.pl>
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: pl
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: JDBC problem
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200008/143

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