Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3aM2-00DPau-93 for pgsql-general@arkaria.postgresql.org; Wed, 23 Oct 2024 12:20:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t3aM0-009FH3-7g for pgsql-general@arkaria.postgresql.org; Wed, 23 Oct 2024 12:20:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3D6a-00GfJg-7K for pgsql-general@lists.postgresql.org; Tue, 22 Oct 2024 11:31:16 +0000 Received: from lvps91-250-99-172.dedicated.hosteurope.de ([91.250.99.172]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3D6X-002Nno-VA for pgsql-general@lists.postgresql.org; Tue, 22 Oct 2024 11:31:15 +0000 Received: from HAPPIX (bry-it.net [37.24.105.49]) by lvps91-250-99-172.dedicated.hosteurope.de (Postfix) with ESMTPSA id EA35EF954F for ; Tue, 22 Oct 2024 13:28:55 +0200 (CEST) From: "Rossana Ocampos" To: Subject: CURRENTE_DATE Date: Tue, 22 Oct 2024 13:31:12 +0200 Message-ID: <00b001db2475$e6584640$b308d2c0$@bry-it.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00B1_01DB2486.A9E275D0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AdskdSJYU0pa1txXTxCphvgijCaIWw== Content-Language: de List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_00B1_01DB2486.A9E275D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_00B1_01DB2486.A9E275D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

------=_NextPart_000_00B1_01DB2486.A9E275D0--