Yeah. What I have to figure out is how to use this with DBIx::Class since it is
using ? placeholders behind the scenes, and I'm getting errors about mixing ?
and $1 placeholders. I haven't had a chance to look inside DBIx to see what's
involved in changing that. Thanks for the help-
Augustus
O
Keep in mind that those dollar-names are a PostgreSQL specific feature, their
native way to refer positional routine parameters. In your Perl code the SQL
will have to be making those literals, eg non-interpolating dollar signs. --
Darren Duncan
On 2014-12-17 10:28 AM, Augustus Saunders wrote
Interesting, thanks for the information. I hadn't realized that you could use
$1, $2 etc at the DBI/bind level. I do have queries where the same value is
repeated, so that should be helpful regardless of the ? class of operators.
Augustus
On Dec 16, 2014, at 8:19 PM, Darren Duncan wrote:
> On
On 2014-12-04 3:38 PM, Augustus Saunders wrote:
Hi all, I have been unable to find a way to use some of the new JSONB operators
in Postgres 9.4 with DBIx::Class. A quick search for JSONB on the email archive
site didn’t turn up any results, so I thought I would ask.
In particular, ?, ?&, and ?|
Hi all, I have been unable to find a way to use some of the new JSONB operators
in Postgres 9.4 with DBIx::Class. A quick search for JSONB on the email archive
site didn’t turn up any results, so I thought I would ask.
In particular, ?, ?&, and ?| are now operators, and we run into problems with
