Re: [PyGreSQL] should dictresult warn if column name is reused ?

2019-01-21 Thread D'Arcy Cain
On 1/21/19 3:41 PM, Justin Pryzby wrote: > -- 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,

[PyGreSQL] should dictresult warn if column name is reused ?

2019-01-21 Thread Justin Pryzby
-- 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