-- 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

Reply via email to