Re: CURRENTE_DATE

["Ray O'Donnell" <ray@xxxxxxxxxxxx>]

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@xxxxxxxxxxxx