Re: [HACKERS] Question about simple function folding optimization

2003-06-11 Thread Marc G. Fournier
sorry for delay ... installing opensp right now ... On Sun, 1 Jun 2003, Peter Eisentraut wrote: > Tom Lane writes: > > > (the documentation build at developer.postgresql.org doesn't seem to > > have updated since before the server move :-() > > The program called "onsgmls" (or maybe "nsgmls") i

Re: [HACKERS] Question about simple function folding optimization

2003-06-02 Thread Peter Eisentraut
Tom Lane writes: > (the documentation build at developer.postgresql.org doesn't seem to > have updated since before the server move :-() The program called "onsgmls" (or maybe "nsgmls") is missing. Marc, can you please install it? It should be in a package called "opensp". -- Peter Eisentraut

Re: [HACKERS] Question about simple function folding optimization

2003-05-30 Thread Bruno Wolff III
On Thu, May 29, 2003 at 15:19:09 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > Bruno Wolff III <[EMAIL PROTECTED]> writes: > > Can you use functional expressions in CREATE INDEX now (7.4 CVS) as well? > > You can use expressions. I'm not sure if you mean anything particular > by "functional expr

Re: [HACKERS] Question about simple function folding optimization

2003-05-30 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > Can you use functional expressions in CREATE INDEX now (7.4 CVS) as well? You can use expressions. I'm not sure if you mean anything particular by "functional expressions". See the man page --- http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-cre

Re: [HACKERS] Question about simple function folding optimization

2003-05-30 Thread Bruno Wolff III
On Thu, May 29, 2003 at 13:44:18 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > > I've now done this (amazing what you can do when you're putting off > editing thousands of elog() calls ...), and so Stephan's example > works again: Can you use functional expressions in CREATE INDEX now (7.4 CVS)

Re: [HACKERS] Question about simple function folding optimization

2003-05-30 Thread Tom Lane
Awhile back I said: > [ SQL-function inlining breaks planner's ability to recognize functional > indexes ] > The urge is becoming very strong to fix this by replacing functional > indexes with expressional indexes, as I suggested doing many moons ago. > Then the difficulty at hand would be easil