Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 4DB2B1337B4F
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  7 Dec 2010 17:53:17 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 44408-07 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  7 Dec 2010 21:53:10 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f68.google.com (mail-fx0-f68.google.com
	[209.85.161.68])
	by mail.postgresql.org (Postfix) with ESMTP id A4E67133655C
	for <pgsql-sql@postgresql.org>; Tue,  7 Dec 2010 17:53:09 -0400 (AST)
Received: by fxm16 with SMTP id 16so98239fxm.7
	for <pgsql-sql@postgresql.org>; Tue, 07 Dec 2010 13:53:09 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type;
	bh=LTn9lfjm6qDXom10f5qlCzARtW4LftOTT3MSm7TtW1g=;
	b=WeipMyLcTQ2HxSNm5iK0ilcNy0opZf372swYbe3dyp8+w8CDQJsEsTHj1+olcKwBFH
	PT+YebDn4JF4rAcPgmEr2RIy343BeweAXUsX6kKCDWdaOQz8z3GbFdiGOoa0tmEB0b8x
	Vcm8bhjMOHK81G6jNuaBdXOgSLvR0mv2LffLE=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=onANmKwM+ZBom4zpSeyi3Za5nU6+ipncY07vWx9xNpmhmxh72ossPsNvEjBnfSQBcE
	kCeb8LhZ1xAk7LaMZKjNKayNl06dMLQaJr2vABtMUDevYsmgPb7tGT/e7VjrzwvjP/A6
	4MtDVyQ8M1lMaKRAxibMKODvMcrFrVNH08Isk=
MIME-Version: 1.0
Received: by 10.223.98.198 with SMTP id r6mr7770657fan.96.1291758788962; Tue,
	07 Dec 2010 13:53:08 -0800 (PST)
Received: by 10.223.70.137 with HTTP; Tue, 7 Dec 2010 13:53:08 -0800 (PST)
In-Reply-To: <1291758466.16970.19.camel@tony1.localdomain>
References: <1291757825.16970.18.camel@tony1.localdomain>
	<AANLkTi=cdwqU0DtFf68BuD=wb3tWfCToe4hn_AUWJFpQ@mail.gmail.com>
	<1291758466.16970.19.camel@tony1.localdomain>
Date: Tue, 7 Dec 2010 13:53:08 -0800
Message-ID: <AANLkTikCaJVDTbCDm1DAOGY684zE-rYhTWAYOR1h1UTc@mail.gmail.com>
Subject: Re: concatenate question
From: Richard Broersma <richard.broersma@gmail.com>
To: Tony Capobianco <tcapobianco@prospectiv.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7
X-Spam-Level: 
X-Archive-Number: 201012/39
X-Sequence-Number: 34875

On Tue, Dec 7, 2010 at 1:47 PM, Tony Capobianco
<tcapobianco@prospectiv.com> wrote:
> Why did I need to cast both as text though?

http://www.postgresql.org/docs/8.3/interactive/release-8-3.html#AEN87134

-- 
Regards,
Richard Broersma Jr.