Thanks. Then we have an inconsistency between this and the documentation for the || operator, where it is showing the abilty to concat numeric types without explicit casting. http://www.postgresql.org/docs/8.3/static/functions-string.html > -----Original Message----- > From: pgsql-admin-owner@xxxxxxxxxxxxxx > [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Milen A. Radev > Sent: Saturday, December 06, 2008 12:49 PM > To: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: Change in behavior of string concat operator > > Benjamin Krajmalnik написа: > > I just migrated from 8.1 to 8.3, running on FreeBSD 7.0 amd64. > > Running 8.3.5 > [...] > > Select userid::varchar || accountno::varchar || > requestdate::date as > > newcolumn from table At the very least, the documentation should be > > updated to reflect the new behavior, although I believe > this is a bug. > > > http://www.postgresql.org/docs/current/static/release-8-3.html > #AEN86272 > > > > -- > Milen A. Radev > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
