Re: plpython integer types

On Thu, Nov 17, 2005 at 03:46:46PM +0100, Emiliano Amilcarelli wrote:
> No, it doesn,'t work if i use int4

int4 works for me in PostgreSQL 8.1.0 and 8.0.4:

CREATE TABLE foo (
    i  integer,
    f  float8,
    n  numeric,
    t  text,
    d  date
);

CREATE FUNCTION populate() RETURNS boolean AS $$
query = 'INSERT INTO foo (i, f, n, t, d) VALUES ($1, $2, $3, $4, $5)'
types = ('int4', 'float8', 'numeric', 'text', 'date')
plan = plpy.prepare(query, types)
plpy.execute(plan, (1, 2.3, 4.56, 'test', '2005-11-17'))
return True
$$ LANGUAGE plpythonu VOLATILE;

SELECT populate();
 populate
----------
 t
(1 row)

SELECT * FROM foo;
 i |  f  |  n   |  t   |     d
---+-----+------+------+------------
 1 | 2.3 | 4.56 | test | 2005-11-17
(1 row)

--
Michael Fuhr