Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re^2: Getting id of postgres record inserted via DBI

by erix (Prior)
on Jun 22, 2023 at 16:19 UTC ( [id://11153088]=note: print w/replies, xml ) Need Help??


in reply to Re: Getting id of postgres record inserted via DBI
in thread Getting id of postgres record inserted via DBI

Modern PostgreSQL supports the RETURNING keyword.

s/Modern /Since time immemorial /;

because INSERT ... RETURNING * is in PostgreSQL since 2006, version 8.2.

Replies are listed 'Best First'.
Re^3: Getting id of postgres record inserted via DBI
by marto (Cardinal) on Jun 22, 2023 at 16:21 UTC

    For some people, 2006 tech is futuristic :P

      I agree that i'm old, yes. I started with PostgreSQL 7 or something like that (after having to work with Oracle for many years).

      PerlMonks XP is useless? Not anymore: XPD - Do more with your PerlMonks XP

        That's not too bad; I was made to work with Oracle 5.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (5)
As of 2025-06-13 08:07 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.