CodeIgniter Forums
postgres UPDATE query RETURNING data help - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: postgres UPDATE query RETURNING data help (/showthread.php?tid=39624)



postgres UPDATE query RETURNING data help - El Forum - 03-16-2011

[eluser]_TubbZ_[/eluser]
Hello,

I am using the database query method to execute an update to my postgres database and in the query I am using the RETURNING sql statement to return a value from the updated record. My problem is that CI detects that its an update query and throws the result set away. Is there a way I can get to this returned data? Or will I just have to execute another query to get the result without having to fiddle with CI System files?

Any help is greatly appreciated, Thanks.


postgres UPDATE query RETURNING data help - El Forum - 03-16-2011

[eluser]_TubbZ_[/eluser]
No takers? Sad