Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^7: SELECT LAST_INSERT_ID does not work

by chacham (Prior)
on Jul 02, 2017 at 04:09 UTC ( [id://1194026]=note: print w/replies, xml ) Need Help??


in reply to Re^6: SELECT LAST_INSERT_ID does not work
in thread SELECT LAST_INSERT_ID does not work

I think Oracle's version is "correct" because it completely separates what is returned into variables. Those variables are defined by the caling environment like any variables are. I do not see that as kludgy at all. Perhaps it is "pure sql" because it requires the use of a caller.

On the other hand, i have never used PostreSQL, i just consider it as being similar to Oracle in (most) practice.

  • Comment on Re^7: SELECT LAST_INSERT_ID does not work

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1194026]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (3)
As of 2025-06-21 07:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.