Re: Between Node
От | Rod Taylor |
---|---|
Тема | Re: Between Node |
Дата | |
Msg-id | 1026992174.280.58.camel@jester обсуждение исходный текст |
Ответ на | Re: Between Node ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>) |
Ответы |
Re: Between Node
|
Список | pgsql-patches |
On Thu, 2002-07-18 at 00:56, Christopher Kings-Lynne wrote: > I believe Tom mentioned that having BETWEEN as a node would allow him to do > some sort of funky optimiser improvement. Is that already done or does he > still need to do it? I don't know what improvement this would be. I only touched the parser and executor. It only executes each segment of the between tree once so the only optimization I can think of would be to try to execute the most likely to fail leaf first. > > -----Original Message----- > > From: pgsql-patches-owner@postgresql.org > > [mailto:pgsql-patches-owner@postgresql.org]On Behalf Of Bruce Momjian > > Sent: Thursday, 18 July 2002 12:42 PM > > To: Rod Taylor > > Cc: pgsql-patches@postgresql.org > > Subject: Re: [PATCHES] Between Node > > > > > > > > Patch applied. Thanks. > > > > ------------------------------------------------------------------ > > --------- > > > > > > Rod Taylor wrote: > > > Finished the Between patch Christopher started. > > > > > > Implements between (symmetric / asymmetric) as a node. > > > > > > Executes the left or right expression once, makes a Const out of the > > > resulting Datum and executes the >=, <= portions out of the Const sets. > > > > > > Of course, the parser does a fair amount of preparatory work for this to > > > happen. > > > > [ Attachment, skipping... ] > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 6: Have you searched our list archives? > > > > > > http://archives.postgresql.org > > > > -- > > Bruce Momjian | http://candle.pha.pa.us > > pgman@candle.pha.pa.us | (610) 853-3000 > > + If your life is a hard drive, | 830 Blythe Avenue > > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
В списке pgsql-patches по дате отправления: