Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Implementing PostgreSql returning statement
Implementing PostgreSql returning statement [message #50044] Tue, 26 June 2018 19:43 Go to previous message
busiek is currently offline  busiek
Messages: 65
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.
 
Read Message
Read Message
Read Message
Previous Topic: SOLVED MySQL on remote DB: timeout or other issue
Next Topic: PostgreSQL NaN fetching from DB
Goto Forum:
  


Current Time: Sun Jul 14 04:01:34 CEST 2024

Total time taken to generate the page: 0.02125 seconds