Search Postgresql Archives

Re: KeyError: self._index[x]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Shall I loop using the 'translate' as key to my row?

On Tue, May 8, 2018 at 12:10 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 05/07/2018 08:11 PM, tango ward wrote:
Sorry, accidentally pressed send.


cur_p = conn_pr(cursor_factory=psycopg2.extras.DictCursor)
cur_t = conn_t.cursor(cursor_factory=psycopg2.extras.DictCursor)


cur_t.execute("""
                 SELECT TRANSLATE(snumber, ' ', '')
                 FROM sprofile """)


DictCursor is a hybrid dict/sequence.

# This will result in KeyError
for row in cur_t:
print row['snumber']

Above you are using it as a dict and as David pointed you would need to use translate as the key:

test=> select translate('test', '', '');
 translate
-----------
 test



# This works fine
for row in cur_t:
print row[0]

Above you are using as a sequence, so the indexing works.



Sorry again.

I would really appreciate any suggestions.

Thanks,
J



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux