Re: CONCAT function equivalent - Mailing list pgsql-admin

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