On 2013-02-28, Marko Rihtar wrote:
> --047d7b603fca8e330f04d6c63f7b
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi all,
>
> i have a little problem.
> cv1 := CONCAT(cv1, DECODE(TO_HEX(11), 'escape'));
what's that supposed to do? if I were to fix it how would I know?
--
⚂⚃ 100% natur
On 28/02/13 10:21, Marko Rihtar wrote:
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:
You seem to be mixing up escape and hex literal formatting along with
decode(). The following should
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
