| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | jian he <jian(dot)universality(at)gmail(dot)com> |
| Cc: | Peter Eisentraut <peter(at)eisentraut(dot)org>, Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, Vik Fearing <vik(at)postgresfriends(dot)org>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: implement CAST(expr AS type FORMAT 'template') |
| Date: | 2026-07-15 14:44:12 |
| Message-ID: | CA+TgmoaVc50Mw2mraQZ35Ukv+VT9u8N3Yk8PuouD=OLhYamDsw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jul 15, 2026 at 5:11 AM jian he <jian(dot)universality(at)gmail(dot)com> wrote:
> src8=# select cast('2012-13-12' as date format 'YYYY-MM-DD' );
> ERROR: date/time field value out of range: "2012-13-12"
>
> With this example, I hope I've convinced you that it's still worthwhile to have
> the parser build a FuncExpr for CAST ... FORMAT, even though that same FuncExpr
> could otherwise be produced by calling the to_* function directly.
How does this show that? Why not just call the to_* function directly?
--
Robert Haas
EDB: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Gustafsson | 2026-07-15 14:50:14 | Re: CI failure: postgres_fdw_get_connections |
| Previous Message | Fujii Masao | 2026-07-15 14:30:54 | Re: CI failure: postgres_fdw_get_connections |