Postgres Pro
Downloads
Home   >   mailing lists

Re: AT TIME ZONE INTERVAL and prepared statements - Mailing list pgsql-bugs

From Tom Lane
Subject Re: AT TIME ZONE INTERVAL and prepared statements
Date
Msg-id 19433.1098483364@sss.pgh.pa.us
Whole thread Raw
In response to AT TIME ZONE INTERVAL and prepared statements  (Kris Jurka <books@ejurka.com>)
Responses Re: AT TIME ZONE INTERVAL and prepared statements  (Kris Jurka <books@ejurka.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Kris Jurka
Date:
Subject: AT TIME ZONE INTERVAL and prepared statements
Next
From: Marc Boucher
Date:
Subject: Problem with rule and null value