Re: [HACKERS] Alternative to LIMIT in SELECT ?

Applied, with one question.

> >>> I've found ExecutorLimit() (in executor/execMain.c) is useful for me
> >>> especially when issuing an ad-hock query via psql. I personally use
> >>> the function with customized set command.
> >>
> >>Looks interesting. So where are the patches? :)
> >
> >I'll post pacthes within 24 hours:-)
>
> Here it is.
> + #ifdef QUERY_LIMIT
> + static bool
> + parse_query_limit(const char *value)
> + {
> + int32 limit;
> +
> + if (value == NULL) {
> + reset_query_limit();
> + return(TRUE);
> + }

Any idea how 'value' could be null? I could not see how that would
happen. I can see how GEQO could have a NULL when you say ON, and no
value. Same with rplans.

--
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