Re: Problem with extract function ?
| От | Esteban Zimanyi |
|---|---|
| Тема | Re: Problem with extract function ? |
| Дата | |
| Msg-id | CAPqRbE5aYhgEcmaJUrTH+0jxvxNNHJWCS=sqvuDFOGsoSBhwDA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Problem with extract function ? (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-bugs |
Many thanks to both of you Tom and Eric for your prompt response.
I installed 13.1 and now the problem is solved. The consequence of this exchange is that I can now test MobilityDB on the brand new version of PostgreSQL :-)
Regards
On Thu, Nov 12, 2020 at 4:32 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Esteban Zimanyi <ezimanyi@ulb.ac.be> writes:
> NorthwindDW=# select current_date as today , extract(week from
> current_date) as weeknbyear;
> 2020-11-12 13:25:21.217 CET [20130] ERROR: syntax error at or near
> "weeknbyear" at character 67
That works fine for me. However, I can reproduce the syntax error
if I misspell "as":
# select current_date as today , extract(week from
current_date) ss weeknbyear;
ERROR: syntax error at or near "weeknbyear"
LINE 2: current_date) ss weeknbyear;
^
This leads me to suspect that you have some weird invisible character
(non-break space, zero-width space, etc) adjacent to "as". Postgres
is not terribly forgiving of non-ASCII whitespace.
regards, tom lane
В списке pgsql-bugs по дате отправления: