Re: AT TIME ZONE INTERVAL and prepared statements

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