Re: DBD-Pg Placeholder usage in v 1.49
Tom Lane <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
Max Pyziur <[email protected]> writes: > FROM prices aa, oi_vol_tmp bb > WHERE aa.pr_date = bb.pr_date > AND symbol = ? > AND aa.pr_date BETWEEN date ? - integer ? AND ? > I've tried using: > AND aa.pr_date BETWEEN date ?::date - integer ?::int AND ?::date > with no success. It should just be ... AND aa.pr_date BETWEEN ?::date - ?::int AND ?::date The type-name-at-the-front syntax is redundant with the cast, and is only allowed for simple literal constants anyway. It worked for you before because DBD-PG was replacing the ? marks with literal strings, but it wasn't ever really "the right thing". See http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS-GENERIC regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate