Search Postgresql Archives

Advanced query rewrite

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux