Postgres Pro
Downloads
Home   >   mailing lists

Re: The result of the last function call overwrites the result of previous function calls - Mailing list pgsql-general

From Tom Lane
Subject Re: The result of the last function call overwrites the result of previous function calls
Date
Msg-id 22104.1396023433@sss.pgh.pa.us
Whole thread Raw
In response to The result of the last function call overwrites the result of previous function calls  (Michael Ainsworth <michael.ainsworth@abri.une.edu.au>)
List pgsql-general
Tree view 
Michael Ainsworth <michael.ainsworth@abri.une.edu.au> writes:
> My question is: Can someone please enlighten me as to why the result of the last function call overwrites the results
tothe 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

pgsql-general by date:

Previous
From: Markella Skempri
Date:
Subject: 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
Next
From: Igor Neyman
Date:
Subject: Re: Help with exclusion constraint