From: | Matthias Apitz <guru(at)unixarea(dot)de> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef' |
Date: | 2023-04-25 12:41:45 |
Message-ID: | ZEfKic3n/58EOpoa@pureos |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
We're using the above DBD::Pg version on Linux together with PostgreSQL 15.1
On fetch empty char columns are returned as (Perl) 'undef'
while ( my @row_ary = $dba->FetchArray()) {
foreach my $i (0..$#row_ary) {
if ($row_ary[$i] eq undef) {
print $row_ary[1] . "\n";
next;
}
...
which later leads in our code to NULL values '\N' in the writing of a CSV-like export
files. Ofc NULL values in the database are something else as '' char
strings.
How this must be distinguished with DBD::Pg?
Thanks
matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Wienhold | 2023-04-25 12:53:09 | Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist |
Previous Message | gzh | 2023-04-25 11:34:56 | Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist |