Thanks everyone - 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.
Jeff -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 21, 2017, at 12:54 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > That should work without problems. PgSQL Select and PgSQL Execute mostly do > the same things except Execute does not return rows. The "returning" clause > makes it a set returning SQL command so PgSQL Select is the right plugin > command. > > John DeSoi, Ph.D. > > >> On Sep 21, 2017, at 9:37 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> We're using the Pluggers PostgreSQL plug-in, and trying to capture the ID of >> newly inserted rows. It seems like the best way to do this is to put the >> insert into a Select. The following seems to work, but we've just never done >> this before and it seems weird... :) Anything to worry about here? ********************************************************************** 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 **********************************************************************
