Re: [HACKERS] char(8) vs char8

Thus spake Byron Nikolaidis
> > string 'abc' would return 'abc' as expected. Now, with char(8), I get
> > back 'abc ' instead. You can see this with my PygreSQL module
>
> Couldn't you use something like "select rtrim(column) from table". This
> will trim the spaces off.

It wouldn't be as convenient as this example.

import pg
for d in pg.connect('database').query('select * from table').dictresult():
print "Num: %(field1)3d, '%(field2)s'" % d

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.