Re: function with unknown params - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: function with unknown params
Date
Msg-id 20130709164914.GG18471@eldon.alvh.no-ip.org
Whole thread Raw
In response to function with unknown params  (giozh <giozh@yahoo.it>)
Responses Re: function with unknown params
List pgsql-general
giozh 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);

You need to enclose the date in quotes, too.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: giozh
Date:
Subject: function with unknown params
Next
From: Raghavendra
Date:
Subject: Re: function with unknown params