Re: Duplicate fields in select_hashref
"Greg Sabino Mullane" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase.devel |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
NotDashEscaped: You need GnuPG to verify this message
>> The fact that count(*) shows up as "count" in the field name isn't driven by
>> DBI - it's driver dependent.
>
> DBD::Pg - "count"
> DBD::Oracle - "count(*)"
> DBD::Unify - "count(*)"
> DBD::CSV - "count(*)"
> DBD::SQLite - "count(*)"
>
> So IMHO a bug in DBD::Pg.
Not so fast there. :) First, DBD::Pg is getting the column name from Postgres.
Second, it may well be that Postgres is doing it *correct* and the other
are wrong. Certainly not echoing a function's arguments as part of the column
name seems a reasonable thing to do to me, legal or not.
postgres=# select length('abcdef');
length
--------
6
mysql> select length('abcdef');
+------------------+
| length('abcdef') |
+------------------+
| 6 |
+------------------+
Well, at least they agree on the "6" :)
--
Greg Sabino Mullane [email protected]
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201001291044
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAktjAn8ACgkQvJuQZxSWSsjA3wCgsCdqJr5UkKtH/fbTRjgm3GPN
8pkAnjUOJd6N3WmalNy+qWz2D40f6Thq
=UgkM
-----END PGP SIGNATURE-----