On Tue, Jul 9, 2013 at 10:00 PM, giozh
<giozh@yahoo.it> wrote:
i've declared and implemented e function like:
CREATE OR REPLACE FUNCTION acquistoLotto(m_g INTEGER, grossista VARCHAR(20),
produttore BIGINT, costo INTEGER, dat DATE, descr VARCHAR(120), num_prod
INTEGER) RETURNS VOID AS $$
but when i'm trying to call it like
select acquistoLotto(0, 'grossista', 52187073424, 10, 22/1/2013, 'ciao ciao
ciao', 10);
Seems you missing on how to pass date field. Try this it will work.
postgres=# select acquistoLotto(0, 'grossista', 52187073424, 10, '1-22-2013', 'ciao ciaociao', 10);
acquistolotto
---------------
(1 row)
or
postgres=# select acquistoLotto(0, 'grossista', 52187073424, 10, '1-22-2013'::date, 'ciao ciaociao', 10);
acquistolotto
---------------
(1 row)
---
Regards,
Raghavendra
EnterpriseDB Corporation