On Mar 13, 2014, at 12:18 PM, Susan Cassidy <susan.cass...@decisionsciencescorp.com> 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general