| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Howie <caffeine(at)toodarkpark(dot)org>, pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] optimizer woes ? |
| Date: | 1999-06-15 20:09:46 |
| Message-ID: | 199906152009.QAA02107@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> The TODO entry is insufficiently ambitious: it should read "implement
> a general-purpose constant-subexpression-reduction step". (Actually,
Changed:
* Convert function(constant) into a constant for index use
> I think that TODO entry might refer to something completely different
> ... wasn't the complaint that you couldn't make an index on
> "date_part('date', field)"? )
This is a separate issue.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-06-15 23:14:44 | Re: [SQL] Maybe a bug with SQL processor |
| Previous Message | Tom Lane | 1999-06-15 19:55:58 | Re: [SQL] optimizer woes ? |