PostgreSQL compilation error

Question

PostgreSQL compilation error

Navigation

#1 by (3 votes)

2

Someone could tell me if there is an error in the query below:

select name, cast(Extract(day from payday) as int) as 'day' from loan;

I can not find the reason for having a compile error in the URI.

sql postgresql

asked by anonymous 05.11.2018 / 01:33

1 answer

How to connect to SQL Server with VB.NET? SASS - beginner (small doubt)

score 3 · Accepted Answer

I thought the problem would be in cast ; I was creating this fiddle and realized that the error message ( 42601: syntax error at or near "'day'" ) is related to the alias , not the extract .

Removing quotation marks, the problem is solved:

select name, cast(Extract(day from payday) as int) as day from loan;