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 <jeffrey.k...@gmail.com> 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************
