On Tuesday 16 September 2003 13:45, Marek Lewczuk wrote:
> Hello,
> As I'm in the middle of the migration process form mysql to pg I found
> that there is no CONCAT function which is available in mysql. Can
> anybody tell me how to implement this function using plPERL or plPGSQL
> language ?
You want to use the || operator, e.g. 'hello' || ' ' || 'world'
Full details of operators and functions can be found in the "data types"
section of the documentation.
--
Richard Huxton
Archonet Ltd