A weird yet occasionally very useful PostgreSQL feature: ROWS FROM [ WITH ORDINALITY ]. Full outer "joining" two tables by ordinalitypic.twitter.com/rEBOGFYoJ4
You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
Perhaps the standard's biggest flaw is the way it defines new special cases for everything, rather than provide generic mechanisms.
Hmm, the generic mechanism is to project row_number() on both data sources, and then full outer joining on that row number, right? But it's quite verbose.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.