> > You want to use the || operator, e.g. 'hello' || ' ' || 'world' I know that, but in my application (which is working on MySQL now) I have many querys which use CONCAT function, so I need to implement this function is PG - there is no possibility to replace (in short time) all of my querys.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html