concatenating text and bytea

[Vincent de Phily <vincent.dephily@xxxxxxxxxxxxxxxxx>]

Hi,

 

I got recently bitten by this :

 

# select 'ascii'::text || E'\\xdeadbeef'::bytea, pg_typeof('ascii'::text || '\xdeadbeef'::bytea), 'ascii'::bytea || E'\\xdeadbeef'::bytea;

?column? | pg_typeof | ?column?

-----------------+-----------+----------------------

ascii\xdeadbeef | text | \x6173636969deadbeef

 

 

I would have expected a result cast as bytea or an error message telling me about incompatible types, but the result from the first column is a nasty gotcha. Is it the intented behaviour ?

 

 

--

Vincent de Phily