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

2019-01-22 Thread Christoph Zwerschke
Am 21.01.2019 um 22:41 schrieb 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

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