Re: [BUGS] AT TIME ZONE INTERVAL and prepared statements

2004-10-22 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > On Fri, 22 Oct 2004, Tom Lane wrote: >> You are confusing the syntax for a typed literal with part of the AT >> TIME ZONE construct. > Could you explain what the difference is between a typed literal > "int '11'" and a cast(ed) literal "'11'::int" to me the

Re: [BUGS] AT TIME ZONE INTERVAL and prepared statements

2004-10-22 Thread Kris Jurka
On Fri, 22 Oct 2004, Tom Lane wrote: > You are confusing the syntax for a typed literal with part of the AT > TIME ZONE construct. Could you explain what the difference is between a typed literal "int '11'" and a cast(ed) literal "'11'::int" to me they seem like the same thing. Kris Jurka -

Re: [BUGS] AT TIME ZONE INTERVAL and prepared statements

2004-10-22 Thread Tom Lane
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.