Re: Query a column with the same name as an operator

2020-11-06 Thread Jurrie Overgoor
On 06-11-2020 10:08, Magnus Hagander wrote: On Fri, Nov 6, 2020 at 10:00 AM Java Developer wrote: Hello, I am trying to query a column from a table I migrated from my MYSQL into POSTGRESQL but I seem to be having issues with a few column names. the column name cast is also an operator, I thin

Re: Query a column with the same name as an operator

2020-11-06 Thread Magnus Hagander
On Fri, Nov 6, 2020 at 10:00 AM Java Developer wrote: > > Hello, > > I am trying to query a column from a table I migrated from my MYSQL > into POSTGRESQL but I seem to be having issues with a few column names. > > the column name cast is also an operator, I think zone may also be a > problem. > >

Query a column with the same name as an operator

2020-11-06 Thread Java Developer
Hello, I am trying to query a column from a table I migrated from my MYSQL into POSTGRESQL but I seem to be having issues with a few column names. the column name cast is also an operator, I think zone may also be a problem. MYSQL: OK SELECT id, start_date, local_time, country, city, region, tem