From: | Ray O'Donnell <ray(at)rodonnell(dot)ie> |
---|---|
To: | Rossana Ocampos <rocampos(at)bry-it(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: CURRENTE_DATE |
Date: | 2024-10-23 13:18:36 |
Message-ID: | 01020192b98778c0-78365d74-1341-45c8-b0de-cc6b962afcf9-000000@eu-west-1.amazonses.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 22/10/2024 12:31, Rossana Ocampos wrote:
>
> *Hello ,*
>
> I am new with PostgreSQL and I have a bug. I have created a function
> that has an input variable of type date , in case it does not receive
> value , it has to assume by default the current date.
>
> I have defined it as follows variable DATE DEFAULT CURRENT_DATE, but
> I get the following error.
>
> *_El error _*
>
> ERROR: invalid input syntax for type date: “CURRENT_DATE” LINE 1:
> ...extsupplydate ('1085018'::bigint, '5278'::bigint, 'CURRENT_D... ^
> ERROR: invalid input syntax for type date: “CURRENT_DATE” SQL status:
> 22007 Characters: 78
>
I think you just need to leave off the quotes, as current_date is a
function:
insert into .... values ( ... , current_date, ....);
Also, you don't need to quote the bigint values.
HTH,
Ray.
> Please could you help me, thank you very much.
>
> Rossana
>
--
Raymond O'Donnell // Galway // Ireland
ray(at)rodonnell(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Reftel, Bengt Erik Magnus | 2024-10-23 14:01:24 | Max size per relation for partitioned tables |
Previous Message | Rich Shepard | 2024-10-23 12:55:29 | Re: CURRENTE_DATE |