public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rossana Ocampos <[email protected]>
To: [email protected]
Subject: CURRENTE_DATE
Date: Tue, 22 Oct 2024 13:31:12 +0200
Message-ID: <[email protected]> (raw)

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

 

Please could you help me, thank you very much.

Rossana 

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: CURRENTE_DATE
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox