Horton

Re: Re: [HACKERS] Re: [SQL] MAX() of 0 records.

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Robert B. Easter" <reaster@comptechnews.com>
Cc: Chris Bitmead <chris@bitmead.com>, pgsql-bugs@postgresql.org, pgsql-hackers@postgresql.org
Date: 2000-07-07T18:12:34Z
Lists: pgsql-bugs, pgsql-hackers 
"Robert B. Easter" <reaster@comptechnews.com> writes:
> If you use min(x) or max(x) frequently, isn't it best to make a
> trigger that intercepts x on insert and update, then check it and
> store it somewhere rather than scanning for it everytime?

I believe that's exactly what the original questioner is trying to do...

			regards, tom lane