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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
