Re: CONCAT function equivalent

[Korry Douglas <korry.douglas@xxxxxxxxxxxxxxxx>]

Is there an equivalent command (string) for this example:

UPDATE domain SET settings=CONCAT(settings, 'default_language:', defaultlanguage, ';');

that works and accomplishes the same thing in postgresql v8.4? Thanks.

The concatenation operator is available in 8.4, is there some reason that won't work for you?

UPDATE domain SET settings = settings || 'default_language:' || defaultlanguage || ';';

-- Korry