JDBC problem

From: BogdanKRomski <b(dot)kromski(at)gaschka(dot)pl>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: JDBC problem
Date: 2000-08-22 11:46:36
Message-ID: 39A2681C.4F34EE10@gaschka.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message John Thorhauer 2000-08-22 13:15:56 How about odbc postgres blobs
Previous Message Joonas Makkonen 2000-08-22 09:03:24 SPI_connect problems