No title
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Ricardo Caesar Lenzi
Your email address : ricardo@k1.com.br
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.16 (Conectiva Linux)
PostgreSQL version (example: PostgreSQL-7.1.1): PostgreSQL-7.2devel
Compiler used (example: gcc 2.95.2) : 2.91.66
Please enter a FULL description of your problem:
------------------------------------------------
All the postgres functions, when using python interface, returns values
in wrong data type, text instead integer or float.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Table structure:
ricardo=# \d contato
Table "contato"
Column | Type | Modifiers
------------+---------+-------------------------------------
id_contato | integer | default nextval('contato_id'::text)
nome | text |
fone1 | text |
fone2 | text |
email | text |
Indexes: contato_ix1,
contato_ix2
Python program, using postgresql-7.1.3 server:
[ricardo@ricardo ricardo]$ python
Python 1.5.2 (#1, Jun 18 2000, 03:54:39) [GCC egcs-2.91.66 19990314/Linux]
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
import pg
db=pg.connect("ricardo")
c=db.query("select count(*) from contato").getresult()[0][0]
print repr(c), type(c)
'27' <type 'string'>
c=db.query("select sum(id_contato) from contato").getresult()[0][0]
print repr(c), type(c)
'475' <type 'string'>
c=db.query("select nextval('contato_id')").getresult()[0][0]
print repr(c), type(c)
'1' <type 'string'>
Python program, using postgresql-7.1.2 server:
[ricardo@ricardo ricardo]$ python
Python 1.5.2 (#1, Jun 18 2000, 03:54:39) [GCC egcs-2.91.66 19990314/Linux]
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
import pg
db=pg.connect("ricardo")
c=db.query("select count(*) from contato").getresult()[0][0]
print repr(c), type(c)
27 <type 'int'>
c=db.query("select sum(id_contato) from contato").getresult()[0][0]
print repr(c), type(c)
475 <type 'int'>
c=db.query("select nextval('contato_id')").getresult()[0][0]
print repr(c), type(c)
1 <type 'int'>
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
--