| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Gaetano Mendola <gmendola(at)mbigroup(dot)it> |
| Cc: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Calculated view fields (8.1 != 8.2) |
| Date: | 2007-03-10 05:56:07 |
| Message-ID: | 8036.1173506167@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Gaetano Mendola <gmendola(at)mbigroup(dot)it> writes:
> I can immagine a case when a lower module exports a view to upper layer stating
> the interface as list of fields:
> first_name, last_name, ....
> with an *hidden* field that is a function call that updates the statistics on
> how many time a given record was selected, then this technique can not be used
> anymore starting with 8.2.x.
You're living in a dream world if you think that works reliably in *any*
version of Postgres. But for starters, what is your definition of
"selected" --- pulled from the physical table? Accumulated into an
aggregate? Delivered as a recognizable row to the client? Delivered N
times to the client due to joining N times to some other table?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-03-10 07:59:55 | Re: scan_recycle_buffers |
| Previous Message | Tom Lane | 2007-03-10 05:32:19 | Re: msvc failure in largeobject regression test |