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
The purpose of ROWS FROM (a nonstandard postgres extension) is actually to generalize the (standard) use of unnest() with multiple arguments in a way that works with all set-returning functions.
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.