[SQL] Concatenating bytea types...

2013-02-28 Thread Marko Rihtar
Hi all, i have a little problem. I'm trying to rewrite one procedure from mysql that involves bytes concatenation. This is my snippet from postgres code: ... cv1 bytea; ... cv1 := E'\\000'::bytea; ... cv1 := CONCAT(cv1, DECODE(TO_HEX(11), 'escape')); ... this third line throws following error: inv

[SQL] SQL - update table problem...

2006-11-13 Thread Marko Rihtar
Hi, first i'm sorry if this message appears twice. first time didn't get through because i wasn't registered. i'm trying to do update on multiple tables but don't know how. is something like this posible with postgresql? update table1 join table2 on (table1.id=table2.t1) join table3 on (table