[HACKERS] Re: [COMMITTERS] pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c)

2000-10-27 Thread Philip Warner
[To hackers this time] At 12:11 27/10/00 +0900, Hiroshi Inoue wrote: For example,LIMIT ALL means LIMIT 1 for optimizer and means no LIMIT for executor. Comments ? It seems there's two possibilities: (a) You know you will only use a limited number of rows, but you are not sure exactly how

[HACKERS] Re: [COMMITTERS] pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c)

2000-10-27 Thread Philip Warner
[To hackers this time] At 20:59 26/10/00 -0400, Tom Lane wrote: Hiroshi Inoue [EMAIL PROTECTED] writes: Yes I want to give optimizer a hint "return first rows fast". When Jan implemented LIMIT first,there was an option "LIMIT ALL" and it was exactly designed for the purpose. Well, we could

Re: [HACKERS] Re: [COMMITTERS] pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c)

2000-10-27 Thread Ross J. Reedstrom
On Fri, Oct 27, 2000 at 09:21:23PM +1000, Philip Warner wrote: [To hackers this time] At 20:59 26/10/00 -0400, Tom Lane wrote: Hiroshi Inoue [EMAIL PROTECTED] writes: Yes I want to give optimizer a hint "return first rows fast". When Jan implemented LIMIT first,there was an option