On Mar 13, 2014, at 12:18 PM, Susan Cassidy
<[email protected]> wrote:
> I copied and pasted the query from the program's log file, so I know I'm
> doing the exact same query. If it matters, I'm only seeing the rows with
> 'root' in them via DBI, which the CASE statement refers to.
Try enabling full query logging on postgres to see what query is actually
running both times. %' shouldn't resolve to anything in perl, but there could
be other issues with misquoting the query.
~ john
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
