Ahh, thanks for the clarification (and to Dave Adams). That makes sense. We'll stick with the 'returning' clause.
-- Jeffrey Kain [email protected] > On Sep 21, 2017, at 1:23 PM, John DeSoi via 4D_Tech <[email protected]> > wrote: > > PgSQL Get Last Insert Row ID is not the same thing - it returns the OID > (object identifier) for the row. OIDs are depreciated and not created by > default for a table unless you include WITH OIDS in your CREATE TABLE > statement (or change the parameter default). Assuming what you are after is > the "id" column value of your table, the returning clause is what you want. > If you use PgSQL Get Last Insert Row ID, you would have to execute another > query to lookup the row by OID and then get the value. > > John DeSoi, Ph.D. > > > >> On Sep 21, 2017, at 11:57 AM, Jeffrey Kain <[email protected]> wrote: >> >> Lee, you were right, there's a PgSQL Get Last Insert Row ID function that's >> also available in the plug-in. They seem to do the same thing. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
