Re: Change in behavior of string concat operator

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Benjamin Krajmalnik <kraj(at)illumen(dot)com>
Cc: "Milen A(dot) Radev" <milen(at)radev(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Change in behavior of string concat operator
Date: 2008-12-08 16:57:52
Message-ID: 20081208085523.Y47606@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, 8 Dec 2008, Benjamin Krajmalnik wrote:

> 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

What that page appears to say in the note and table is that you can
concatenate a string and a non-string like varchar and integer, not
multiple non-strings like numeric and integer. What specifically were you
looking at on the page?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2008-12-08 17:09:46 Re: Change in behavior of string concat operator
Previous Message Milen A. Radev 2008-12-08 16:57:00 Re: Change in behavior of string concat operator