Horton

Re: Stupid question: concatenating strings

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: justinlong@strategicnetwork.org
Cc: pgsql-novice@hub.org
Date: 2000-10-18T17:21:48Z
Lists: pgsql-novice 
The string concatenation operator in SQL is ||, not +.

Also, substr's start-index argument counts from 1 not 0.  Otherwise
you've got the right idea...

			regards, tom lane