MIME-Version: 1.0
References: <00b001db2475$e6584640$b308d2c0$@bry-it.com> <01020192b98778c0-78365d74-1341-45c8-b0de-cc6b962afcf9-000000@eu-west-1.amazonses.com>
In-Reply-To: <01020192b98778c0-78365d74-1341-45c8-b0de-cc6b962afcf9-000000@eu-west-1.amazonses.com>
From: Muhammad Ikram <me.mikram@gmail.com>
Date: Thu, 24 Oct 2024 18:01:09 +0500
Message-ID: <CAJQ7xG5bxJV0+J-K1Sjxb6bA7j+Vi7smmoww7Z_7ThTgsmmvDA@mail.gmail.com>
Subject: Re: CURRENTE_DATE
To: "Ray O'Donnell" <ray@rodonnell.ie>
Cc: Rossana Ocampos <rocampos@bry-it.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000633668062538995e"
Archived-At: <https://www.postgresql.org/message-id/CAJQ7xG5bxJV0%2BJ-K1Sjxb6bA7j%2BVi7smmoww7Z_7ThTgsmmvDA%40mail.gmail.com>
Precedence: bulk

--000000000000633668062538995e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

I am just thinking, when DEFAULT CURRENT_DATE is being used in table
definition then why the function is again being used in INSERT statement
why not use
default. Here is sample


edb=3D# create table date_test (id int, hiredate date default current_date)=
;
CREATE TABLE
edb=3D# insert into date_test values (1, *default*);
INSERT 0 1
edb=3D# select * from date_test;
 id |      hiredate
----+--------------------
  1 | 24-OCT-24 00:00:00
(1 row)

Regards,
Ikram


On Wed, Oct 23, 2024 at 6:18=E2=80=AFPM Ray O'Donnell <ray@rodonnell.ie> wr=
ote:

> 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: =E2=80=9CCURRENT_DATE=E2=80=9D=
 LINE 1:
> ...extsupplydate ('1085018'::bigint, '5278'::bigint, 'CURRENT_D... ^ ERRO=
R:
> invalid input syntax for type date: =E2=80=9CCURRENT_DATE=E2=80=9D SQL st=
atus: 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 // Irelandray@rodonnell.ie
>
>

--000000000000633668062538995e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>I am just thinking, when DEFAULT CU=
RRENT_DATE is being used in table definition then why the function is again=
=C2=A0being used in INSERT statement why not use</div><div>default. Here is=
 sample</div><div><br></div><div><br>edb=3D# create table date_test (id int=
, hiredate date default current_date);<br>CREATE TABLE<br>edb=3D# insert in=
to date_test values (1, <b>default</b>);<br>INSERT 0 1<br>edb=3D# select * =
from date_test;<br>=C2=A0id | =C2=A0 =C2=A0 =C2=A0hiredate<br>----+--------=
------------<br>=C2=A0 1 | 24-OCT-24 00:00:00<br>(1 row)<br></div><div><br>=
</div><div>Regards,</div><div>Ikram</div><div><br></div></div><br><div clas=
s=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Oct 23, 202=
4 at 6:18=E2=80=AFPM Ray O&#39;Donnell &lt;<a href=3D"mailto:ray@rodonnell.=
ie">ray@rodonnell.ie</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204=
);padding-left:1ex"><u></u>

 =20
   =20
 =20
  <div>
    <div>On 22/10/2024 12:31, Rossana Ocampos
      wrote:<br>
    </div>
    <blockquote type=3D"cite">
     =20
     =20
     =20
      <div>
        <p class=3D"MsoNormal"><b><span lang=3D"EN-US">Hello ,<u></u><u></u=
></span></b></p>
        <p class=3D"MsoNormal"><span lang=3D"EN-US">I am new with PostgreSQ=
L
            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.<u></u><u>=
</u></span></p>
        <p class=3D"MsoNormal"><span lang=3D"EN-US">I have defined it as
            follows variable =C2=A0DATE DEFAULT CURRENT_DATE, but I get the
            following error.<u></u><u></u></span></p>
        <p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></s=
pan></p>
        <p class=3D"MsoNormal"><b><u><span lang=3D"EN-US">El error <u></u><=
u></u></span></u></b></p>
        <p class=3D"MsoNormal"><span lang=3D"EN-US">ERROR: invalid input
            syntax for type date: =E2=80=9CCURRENT_DATE=E2=80=9D LINE 1:
            ...extsupplydate (&#39;1085018&#39;::bigint, &#39;5278&#39;::bi=
gint,
            &#39;CURRENT_D... ^ ERROR: invalid input syntax for type date:
            =E2=80=9CCURRENT_DATE=E2=80=9D SQL status: 22007 Characters: 78=
</span></p>
      </div>
    </blockquote>
    <br>
    I think you just need to leave off the quotes, as current_date is a
    function:<br>
    <br>
    =C2=A0 insert into .... values ( ... , current_date, ....);<br>
    <br>
    Also, you don&#39;t need to quote the bigint values.<br>
    <br>
    <br>
    HTH,<br>
    <br>
    Ray.<br>
    <br>
    <br>
    <blockquote type=3D"cite">
      <div>
        <p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u><u></u></span></=
p>
        <p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></s=
pan></p>
        <p class=3D"MsoNormal"><span lang=3D"EN-US">Please could you help
            me, thank you very much.<u></u><u></u></span></p>
        <p class=3D"MsoNormal"><span lang=3D"EN-US">Rossana <u></u><u></u><=
/span></p>
      </div>
    </blockquote>
    <br>
    <br>
    <pre cols=3D"72">--=20
Raymond O&#39;Donnell // Galway // Ireland
<a href=3D"mailto:ray@rodonnell.ie" target=3D"_blank">ray@rodonnell.ie</a><=
/pre>
  </div>

</blockquote></div>

--000000000000633668062538995e--