| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Wellie Chao" <wchao(at)yahoo(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1720: placeholders do not work with timestamp prefix |
| Date: | 2005-06-18 05:54:26 |
| Message-ID: | 9443.1119074066@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Wellie Chao" <wchao(at)yahoo(dot)com> writes:
> I am using DBI 1.48 and DBD::Pg 1.42 (the programming language is obviously
> Perl) to connect to PostgreSQL 8.0.0. The following statements cause
> problems:
> 2005-06-17 16:21:41 EDT LOG: statement: select * from reservation_tbl where
> room_id = $1 and (start_dt, end_dt) overlaps (timestamp $2, timestamp $3)
> 2005-06-17 16:21:41 EDT ERROR: syntax error at or near "$2" at character
> 93
The above is not valid SQL --- the notation "timestamp x" is only legal
when x is a simple string literal. I think you need to complain to the
DBI or DBD::Pg folk, if their code is generating this query.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-06-18 14:41:15 | Re: process crash when a plpython function returns unicode |
| Previous Message | Wellie Chao | 2005-06-17 20:53:03 | BUG #1720: placeholders do not work with timestamp prefix |