X-Git-Url: https://git.exim.org/buildfarm-server.git/blobdiff_plain/fbc70c03af36d901a27ba6426bf436e297892e65..7a251a65acd9d84242e15b47fd7c01405322b2ed:/cgi-bin/show_members.pl diff --git a/cgi-bin/show_members.pl b/cgi-bin/show_members.pl index 5d4a0c9..f6fb396 100755 --- a/cgi-bin/show_members.pl +++ b/cgi-bin/show_members.pl @@ -26,7 +26,7 @@ my $dsn="dbi:Pg:dbname=$dbname"; $dsn .= ";host=$dbhost" if $dbhost; $dsn .= ";port=$dbport" if $dbport; -my $db = DBI->connect($dsn,$dbuser,$dbpass); +my $db = DBI->connect($dsn,$dbuser,$dbpass,{pg_expand_array => 0}); # there is possibly some redundancy in this query, but it makes # a lot of the processing simpler. @@ -34,6 +34,7 @@ my $db = DBI->connect($dsn,$dbuser,$dbpass); my $statement = q{ select name, operating_system, os_version, compiler, compiler_version, owner_email, + sys_notes_ts::date AS sys_notes_date, sys_notes, architecture as arch, ARRAY( select branch || ':' || extract(days from now() - l.snapshot)