The following bug has been logged on the website:
Bug reference: 14428
Logged by: Vadim Bochkov
Email address: vbochkov(at)eastwind(dot)ru
PostgreSQL version: 9.5.5
Operating system: CentOS 7.2
Description:
We have test stored function
CREATE FUNCTION decode_test()
RETURNS integer AS
BEGIN
insert into test2(txt)
select decode('30343134','hex')::varchar(8000);
return 0;
When we execute it from psql command prompt value "0414" is insesrted in
table. When we execute function from agent job value "х30343134" is
inserted in table.
Function decode() is deterministic, but result is not the same. It's bug.