Re: [GENERAL] strange stable function behavior

Thank you very much. It works!!!Where can I read about such features? 2006/6/1, Martijn van Oosterhout : On Thu, Jun 01, 2006 at 03:09:47PM +0400, Dan Black wrote:> Hi> I have a stable function test.test_stable> But if I want to display field sid twice>> SELECT id, sid, sid FROM

Re: [GENERAL] strange stable function behavior

On Thu, Jun 01, 2006 at 03:09:47PM +0400, Dan Black wrote: > Hi > I have a stable function test.test_stable > But if I want to display field sid twice > > SELECT id, sid, sid FROM > (SELECT *, test.test_stable(id) AS sid FROM generate_series(10, 100) AS id) > tbl > > I can see that function te

[GENERAL] strange stable function behavior

HiI have a stable function test.test_stableCREATE OR REPLACE FUNCTION test.test_stable(int4)  RETURNS int4 AS$BODY$DECLARE  _param ALIAS FOR $1;BEGIN  RAISE NOTICE 'ID: %, TIME: %', _param, timeofday()::timestamp;   RETURN _param;END$BODY$  LANGUAGE 'plpgsql' STABLE STRICT SECURITY DEFINER;Everythi