| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: CURRENTE_DATE |
| Date: | 2024-10-23 12:49:54 |
| Message-ID: | ed25647d-3856-337-2a2d-34558214345@appl-ecosys.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 22 Oct 2024, Rossana Ocampos wrote:
> 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.
> 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
Rossana,
I have several tables with default values, including dates. Change your
input's values to `default' (without the quotes.)
Regards,
Rich
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2024-10-23 12:55:29 | Re: CURRENTE_DATE |
| Previous Message | Michel Pelletier | 2024-10-23 04:15:30 | Re: Using Expanded Objects other than Arrays from plpgsql |