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
r...@rodonnell.ie
