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 <[email protected]> > 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:[email protected] **********************************************************************
