Kris Jurka <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
