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