Skip site navigation (1) Skip section navigation (2)

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

From: Ned Wolpert <ned(dot)wolpert(at)knowledgenet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] New backend functions? [was Re: JDBC changes for 7.2.
Date: 2001-08-23 20:03:39
Message-ID: XFMail.20010823130339.ned.wolpert@knowledgenet.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
-----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(dot)wolpert(at)knowledgenet(dot)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(at)postgresql(dot)org)


Virtually, 
Ned Wolpert <ned(dot)wolpert(at)knowledgenet(dot)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-----

In response to

pgsql-hackers by date

Next:From: Florian WeimerDate: 2001-08-23 20:17:05
Subject: Re: Re: Escaping strings for inclusion into SQL queries
Previous:From: Ned WolpertDate: 2001-08-23 20:01:52
Subject: Re: Re: [JDBC] New backend functions? [was Re: JDBC ch

pgsql-jdbc by date

Next:From: Bruce MomjianDate: 2001-08-23 20:17:57
Subject: Re: [PATCHES] patch for JDBC1 build problems
Previous:From: Ned WolpertDate: 2001-08-23 20:01:52
Subject: Re: Re: [JDBC] New backend functions? [was Re: JDBC ch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group