Re: [PERFORM] help: function failing

2014-10-07 Thread Andrew Dunstan
On 10/07/2014 04:41 PM, Sergey Konoplev wrote: On Thu, Oct 2, 2014 at 4:00 PM, George Neuner wrote: --- code CREATE OR REPLACE FUNCTION gen_random() RETURNS double precision AS $BODY$ DECLARE num float8 := 0; den float8 := 281474976710655; -- 0xF

Re: [PERFORM] help: function failing

2014-10-07 Thread Sergey Konoplev
On Thu, Oct 2, 2014 at 4:00 PM, George Neuner wrote: > --- code > CREATE OR REPLACE FUNCTION gen_random() > RETURNS double precision AS > $BODY$ > DECLARE >num float8 := 0; >den float8 := 281474976710655; -- 0x >bytes bytea[6]; > BEGIN >

[PERFORM] help: function failing

2014-10-07 Thread George Neuner
Hi, I am using Postgresql 9.3.5 on Ubuntu and I have a sudden, unexplained failure in a function that has been working for a long time. --- code CREATE OR REPLACE FUNCTION gen_random() RETURNS double precision AS $BODY$ DECLARE num float8 := 0; den floa