Benjamin Krajmalnik написа: > 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 On second reading of your post (and the documentation) we are both wrong - the _string_ concatenation operator works when at least one of the operands is a string. > >> -----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
