-- There are two columns here: >>> pg.DB('ts').query('SELECT x.b, y.a AS b FROM (SELECT 1 AS b )x JOIN (SELECT >>> 1 AS a)y ON true').getresult() [(1, 1)]
-- But here they're silently "collapsed" into one key: >>> pg.DB('ts').query('SELECT x.b, y.a AS b FROM (SELECT 1 AS b )x JOIN (SELECT >>> 2 AS a)y ON true').dictresult() [{'b': 2}] ..which is scary to me since nobody knows what they're going to get, or that same value is being used for two different things instead of different values.. If this is agreed to be a problem, maybe write warning to stderr in 5.0 and fail harder in 5.1+ ? _______________________________________________ PyGreSQL mailing list PyGreSQL@Vex.Net https://mail.vex.net/mailman/listinfo/pygresql