Kris Jurka <books@ejurka.com> writes:
> AT TIME ZONE INTERVAL $1 doesn't seem to be supported in prepared
> statements.
Try
AT TIME ZONE $1
or possibly
AT TIME ZONE $1::interval
You are confusing the syntax for a typed literal with part of the AT
TIME ZONE construct.
regards, tom lane