yes, and then costing and choosing an index based on the expression if it is the best way to execute the query.
Manish Khettry wrote: > On 8/3/05, Mike Matrigali <[EMAIL PROTECTED]> wrote: > >>I don't think I am willing to say generated columns are not useful without >>indexes, sorry if previous email led to that, actually I have not >>actually thought much about it. >> >>I believe I was letting >>my predjudice through, I have always thought that an interesting set >>of problems could be solved if the optimizer work was done - so I >>was concentrating on that. And I see that optimizer work as a stepping >>stone to even more possible interesting stuff in the future - things >>like gist indexes. >> > > > So the optimizer work that you speak of is being able to check if two > expressions are equivalent? >
