Re: The result of the last function call overwrites the result of previous function calls

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Ainsworth <michael(dot)ainsworth(at)abri(dot)une(dot)edu(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: The result of the last function call overwrites the result of previous function calls
Date: 2014-03-28 16:17:13
Message-ID: 22104.1396023433@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Ainsworth <michael(dot)ainsworth(at)abri(dot)une(dot)edu(dot)au> writes:
> My question is: Can someone please enlighten me as to why the result of the last function call overwrites the results to the previous function calls?

Sounds to me like your function is using a static area for its result, or
something along that line.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2014-03-28 16:21:10 Re: Help with exclusion constraint
Previous Message Markella Skempri 2014-03-28 16:03:00 Re: Synchronizing a table that is in two different databases : Need to dump a table as inserts from db1 and change the insert statements into UPDATE statements