2 ms·
Wow. That would be great to have UPSERTS, as mentioned at the end of the post. I've been lugging my RULES/Trigger functions for this feature for years.
by sheraz 13y ago
Wow. That would be great to have UPSERTS, as mentioned at the end of the post.
I've been lugging my RULES/Trigger functions for this feature for years.
- pornel 13y ago> That would be great to have UPSERTS Indeed. Postgres has some amazing features, and yet something so basic has been missing for years. I can't wait for a simple UPSERT, especially that most workarounds work correctly only with 1-row inserts.
- einhverfr 13y agoIn 9.1 and higher, the writable cte's give you multi-row upserts. It isn't particularly simple though.
- adwf 13y agoYeah, this feature would make me incredibly happy. With the current program I'm writing, I swear UPSERTS would cut a good third of the code out.
- jeltz 13y agoThere has been a lot of discussion about which way UPSERT should be implemented so I remain cautious about if it will land in 9.4.