Re: Problem with extract function ?

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Esteban Zimanyi <ezimanyi(at)ulb(dot)ac(dot)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
>