Request a Demo
Home   >   mailing lists

Re: Stupid question: concatenating strings - Mailing list pgsql-novice

From Tom Lane
Subject Re: Stupid question: concatenating strings
Date
Msg-id 5547.971889708@sss.pgh.pa.us
Whole thread Raw
In response to Stupid question: concatenating strings  ("Justin Long" <justinlong@strategicnetwork.org>)
Responses Re: Stupid question: concatenating strings
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Lionel Bargeot
Date:
Subject: problem to compile 7.0.2
Next
From: Bill Morrow
Date:
Subject: Re: Stupid question: concatenating strings