decimal.Decimal('nan') not correctly quoted

paftek <[email protected]>
Newsgroups gmane.comp.python.db.psycopg.devel
Message-ID <[email protected]> 
Hi there,

Unlike float('nan'), decimal.Decimal('nan') is not quoted correctly :

>>> curs.mogrify('%s, %s', [float('nan'), decimal.Decimal('nan')])
"'NaN'::float, NaN"

It should be quoted 'NaN' or 'NaN'::numeric.

Thanks
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.