Does the gridSQL server not use the exact same SQl parser as the backend postgres server?

Many (documented) commands which work on direct connection to postgres server do not seem to work when connected thru the gridSQL server. For example: SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720 * INTERVAL '1 second';

This works fine when connected directly to the postgres server running behind the gridSQL service, but gives this error when entered into the GridSQL prompt: SQLException: ERROR: Encountered "\'epoch\'" at line 1, column 33.

Does the gridSQL server not use the exact same SQl parser as the backend postgres server?

GridSQL has its own parser, so yes, some things may be different, as you have found here.

I will add this an issue to our tracking system.

If you do add support for this, I encourage you to contribute this back to the community. Alternatively, if there are specific features not supported or customization you would like, please contact sales.

Regards,

Mason