what's idiomatic SQL for "insert this row with a new id if it doesn't exist yet, else create a new one and give me its id"?
-
This Tweet is unavailable.
-
this looks like it does what I mean but I refuse to believe that this monstrosity is the "right way"
@MarkusWinand Can you help my Twitter friend with this SQL question? I'll buy you a beer next time we meet.
-
-
In principle: MERGE. However, there is no RETURNING clause in standard SQL. If you want to do it in one shot, you'll need tricks like in SO.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.