[HACKERS] Avoiding execution of some functions by query rewriting

2012-05-16 Thread Thomas Girault
n I change the query execution plan in order to automate the process of query rewriting (q into q') ? Where can I store suitably the metadata about the interval [100,1000] associated to my_function ? Thanks by advance, Thomas Girault

Re: [HACKERS] LIMITing number of results in a VIEW with global variables

2011-10-15 Thread Thomas Girault
Hello Florian, It seems dangerous for a cast to modify global state such a MU. The > evaluation > order of functions during query execute isn't always easy to guess, and may > change depending on the execution plan. I supposed that fuzzy2bool is called just before the terminal evaluation of the

Re: [HACKERS] LIMITing number of results in a VIEW with global variables

2011-10-15 Thread Thomas Girault
hen $1 is converted to Boolean according to ALPHA global value > and instead passing the values you need as function > arguments. Do you mean that I should define a function filter(table_name TEXT, k INTEGER, alpha FLOAT) ? Thanks again for your help, Thomas Girault

[HACKERS] LIMITing number of results in a VIEW with global variables

2011-10-14 Thread Thomas Girault
cts on the MU value. Why is it not working ? How to fix this issue ? Thanks by advance, Thomas Girault -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Module extension for parsing and rewriting functions with infixed syntax

2011-08-06 Thread Thomas Girault
onflicts. Can I define my new bison rules separately of the gram.y file? Can I use the new functionality dynamically after loading an extension module (LOAD 'MY_EXTENSION';)? I am new in the PostgreSQL community and any ideas for solving these problems would be very helpful. Thanks by advance,