-
Notifications
You must be signed in to change notification settings - Fork 31
Open
Description
const q = `SELECT CAST(t.date AT TIME ZONE $$America/New_York$$ AS text)::date FROM tbl t`
const ast = _parse(q)
console.log(_deparse(ast))
// returns SELECT CAST(t.date AT TIME ZONE 'America/New_York'::text AS date) FROM tbl AS tThis causes a SQL error.
A quick fix is to add () to the line below:
https://github.com/launchql/pgsql-parser/blob/main/packages/deparser/src/deparser.ts#L2261
return `(${arg}::${cleanTypeName})`;
Metadata
Metadata
Assignees
Labels
No labels