U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Implementing PostgreSql returning statement

Tue, 26 June 2018 19:43

busiek
Messages: 64
Registered: February 2011
Location: Poland

Member

Hi all,

For my needs I implemented PostgreSql returning statement. Using it is much faster then calling GetInsertedId(). You can use such code:

int id = SQL % Insert(TABLE)(COLUMN1, value1)(COLUMN2, value2).Returning(ID);

I attach a patch. I am not sure whether it could be added to official sources because it is PostgreSql specific.

Tue, 26 June 2018 19:52

unodgs
Messages: 1366
Registered: November 2005
Location: Poland

Ultimate Contributor

Yes, that would be a great addition. I have plenty GetInsertedId's and I'm using Postgres Smile

Wed, 27 June 2018 10:11

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

Applied. Thank you.

Mirek

Previous Topic:	SOLVED MySQL on remote DB: timeout or other issue
Next Topic:	PostgreSQL NaN fetching from DB

Goto Forum:

] [

]

Current Time: Fri Apr 19 19:46:08 CEST 2024

Total time taken to generate the page: 0.01279 seconds