On 16 Sep 2003 at 14:36, Marek Lewczuk wrote: > > > > 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.
Write your own function.. something like text concat(text,text) return text1 || text2 Check up the syntax but you got the idea.. Bye Shridhar -- Friends, n.: People who borrow your books and set wet glasses on them. People who know you well, but like you anyway. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])