Re: function with unknown params

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: giozh <giozh(at)yahoo(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: function with unknown params
Date: 2013-07-09 16:49:14
Message-ID: 20130709164914.GG18471@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra 2013-07-09 16:50:23 Re: function with unknown params
Previous Message giozh 2013-07-09 16:30:35 function with unknown params