I am using code that works correctly when getting data from MSSQL, but does not work correctly when I get data from POSTGRES on a MAC.
I am running my code on the latest MAC OS X Yosemite.
PERL version 5.18
DBI version 1.631
DBD-Pg version 3.4.2
Postgres version 9.3.5
the line of code is:
while (@results = $sth->fetchrow_array) {
$results[0] should contain 'DOE' and $results[1] should contain 'JOHN' like it does for MSSQL
What I get instead for Postgres is $results[0] = '("DOE","JOHN")' and $results[1] contains nothing
Is there something special I need to do for Postgres?
Michael Libeson
I am running my code on the latest MAC OS X Yosemite.
PERL version 5.18
DBI version 1.631
DBD-Pg version 3.4.2
Postgres version 9.3.5
the line of code is:
while (@results = $sth->fetchrow_array) {
$results[0] should contain 'DOE' and $results[1] should contain 'JOHN' like it does for MSSQL
What I get instead for Postgres is $results[0] = '("DOE","JOHN")' and $results[1] contains nothing
Is there something special I need to do for Postgres?
Michael Libeson