Postgres Pro
Downloads
Home   >   mailing lists

Re: Another plpgsql question.. - Mailing list pgsql-general

From Tom Lane
Subject Re: Another plpgsql question..
Date
Msg-id 6298.980265941@sss.pgh.pa.us
Whole thread Raw
In response to Re: Another plpgsql question..  ("Mitch Vincent" <mitch@venux.net>)
List pgsql-general
Tree view 
"Mitch Vincent" <mitch@venux.net> writes:
> is_paid is never updated...

It's not possible that is_paid is never updated; that command *will*
replace the total, updated, and is_paid columns with *something*.
It may be that in the cases you've checked, it gets updated to the
same value it had before.  That's why I want to see the test cases.

            regards, tom lane

pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Another plpgsql question..
Next
From: Bruce Momjian
Date:
Subject: Re: Re: OID/XID allocation (was Re: is PG able to handle a >500 GB Da tabase?)