Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Advanced query rewrite
- From: "Christan Josefsson" <cjosefsson(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Advanced query rewrite
- Date: Mon, 16 Apr 2007 23:42:40 +0200
- Message-id: <a4aab4dc0704161442u419bfbccqc36a24b0fadcf61(at)mail(dot)gmail(dot)com>
Hi!
I was looking into the PostgreSQL RULE system in order to define rewriting / redirecting queries under certain conditions. For my part I would like to fully be able to control the query rewrite, e.g by implemening a stored procedure to define the query rewrite results, since as it seems the means of defining a SELECT RULE doesn't fullfill my requirements. Does anyone know if that would be possible?
What I wan't to achieve is to implement a "agggregare (summary table) navigator" which should transparently rewrite SQL directed to certain large tables to related summary tables instead and for this the RULE system seems too limited (without being able to implement an own rewrite procedure).
Any input on this matter would be much appreciated!
Thanks and Regards,
Christian
- Prev by Date: Re: PITR - "Rewind to snapshot" scheme
- Next by Date: string fields helps
- Previous by thread: delete with self join
- Next by thread: string fields helps
- Indexes: