[HACKERS] Avoiding execution of some functions by query rewriting

2012-05-16 Thread Thomas Girault
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
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

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

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

2011-10-14 Thread Thomas Girault
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
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, Thomas Girault -- Sent via pgsql-hackers mailing list