| From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] Re: type coersion (was OR clause status) |
| Date: | 1998-08-10 02:43:48 |
| Message-ID: | 35CE5E64.F53809A1@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > I claim the parser is doing the wrong thing by representing this as
> > "where int4(i2) = 400::int4" rather than "where i2 = 400::int2".
> > It is not really reasonable to expect the optimizer to clean up
> > after that initial mistake.
> I don't see that.
Yup. The parser is behaving as Bruce describes. The new type conversion
stuff isn't the fundamental problem. It's the original features in the
planner when trying to use indices.
> The problem is how do we use indexes for this? I am still researching
> this.
OK, let me know if I can help look into anything. In the meantime, I'll
keep poking at it a bit...
- Tom
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-08-10 04:50:27 | Re: [HACKERS] Re: type coersion (was OR clause status) |
| Previous Message | Thomas G. Lockhart | 1998-08-10 02:21:57 | Re: [HACKERS] How do I construct a varlena? |