Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: DBD-Pg Placeholder usage in v 1.49
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Max Pyziur <pyz(at)brama(dot)com>
- Cc: pgsql-interfaces(at)postgresql(dot)org
- Subject: Re: DBD-Pg Placeholder usage in v 1.49
- Date: Wed, 16 Jan 2008 12:17:11 -0500
Max Pyziur <pyz(at)brama(dot)com> 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
- Follow-Ups:
- Re: Multiple command usage in DBD-Pg v 1.49
- From: Max Pyziur
- Re: Multiple command usage in DBD-Pg v 1.49
- References:
- DBD-Pg Placeholder usage in v 1.49
- From: Max Pyziur
- DBD-Pg Placeholder usage in v 1.49
- Prev by Date: Re: DBD::Pg 2.0.0 release candidate available for testing
- Next by Date: Re: Multiple command usage in DBD-Pg v 1.49
- Previous by thread: DBD-Pg Placeholder usage in v 1.49
- Next by thread: Re: Multiple command usage in DBD-Pg v 1.49
- Indexes: