Re: Returning oid or primary key - Mailing list pgsql-jdbc

From Bruce Momjian
Subject Re: Returning oid or primary key
Date
Msg-id 200105031742.f43HgNK08146@candle.pha.pa.us
Whole thread Raw
In response to Returning oid or primary key  (Ned Wolpert <ned.wolpert@knowledgenet.com>)
Responses Re: Returning oid or primary key  (Ned Wolpert <ned.wolpert@knowledgenet.com>)
List pgsql-jdbc
> However, _if_ RETURNING is going to be in the standard SQL for the
> next release, _and_ there are plans to update the jdbc driver to take
> advantage of that in the callable statement, as well, then it makes
> more sense _not_ to add my patch that implements the 'overloading' of
> the return value in the jdbc driver.
>
> I guess the issue is the ability to return the primary key from an
> inserted row, for cases that it's auto-generated, such as using the
> serial type.

Certainly the portable solution is to get RETURNING into the backend so
you can decide what you want to return.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-jdbc by date:

Previous
From: "Jerry Reid"
Date:
Subject: Unable to store SHA hash
Next
From: "Dave Cramer"
Date:
Subject: Re: multiple resource sets