Re: New backend functions? [was Re: JDBC changes for 7.2.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I like your function name, get_last_returned_oid().  That works for me.

On 23-Aug-2001 Tom Lane wrote:
> Ned Wolpert <ned.wolpert@knowledgenet.com> writes:
>> Should the backend support the function getLastInsertedOID() or even
>> getLastInsertedPrimaryKey() (or both)?
>
> I don't think you have any chance of doing the latter --- for one thing,
> how are you going to declare that function's return type?  But the
> former seems doable and reasonable to me: whenever an OID is returned
> to the client in an INSERT or UPDATE command result, also stash it in
> a static variable that can be picked up by this function.
>
> Please pick a more SQL-friendly (ie, case insensitive) naming
> convention, though.  And note that it'd apply to both INSERT and UPDATE.
> Maybe get_last_returned_oid() ?
>
>                       regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


Virtually,
Ned Wolpert <ned.wolpert@knowledgenet.com>

D08C2F45:  28E7 56CB 58AC C622 5A51  3C42 8B2B 2739 D08C 2F45
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7hWGbiysnOdCML0URAkqAAJ9Liv8VS+CPMYozG1q1tuy7vGLuEACfUJRM
Hdbns8MxyOVgurx5ztV8YZU=
=BbF3
-----END PGP SIGNATURE-----