Whenever I do inserts like yours, I do it in this kind of manner (I tried
to use your pseudocode style):
SELECT ID FROM ITEM WHERE URL='X' FOR UPDATE
IF (ROW RETURNED) {
$ID = ITEM.ID
} ELSE {
INSERT INTO ITEM ...
GET THE OID [via PQoidStatus or your environment's equivalent]
SELECT ID FR
On Fri, 8 Sep 2000, [iso-8859-1] Cristóvão Dalla Costa wrote:
> I'm working with an application I wrote which does something along these
> lines:
>
> SELECT ID FROM ITEM WHERE URL='X' FOR UPDATE
> IF (ROW RETURNED) {
> $ID = ITEM.ID
> } ELSE {
> SELECT nextval ('item_id_seq')
> $ID =
