Re: [HACKERS] Alternative to LIMIT in SELECT ?

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: t-ishii(at)sra(dot)co(dot)jp
Cc: t-ishii(at)sra(dot)co(dot)jp, lockhart(at)alumni(dot)caltech(dot)edu, marc(at)fallon(dot)classyad(dot)com, eric(at)linux-hw(dot)com, scrappy(at)hub(dot)org, jeff(at)remapcorp(dot)com, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Alternative to LIMIT in SELECT ?
Date: 1998-10-14 16:18:26
Message-ID: 199810141618.MAA26677@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> >> + #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.
>
> Not sure. I just followed the way other set commands are doing.
>
> >I can see how GEQO could have a NULL when you say ON, and no
> >value. Same with rplans.
>
> Hmm... I think in that case, 'value' would be 'ON', not NULL. right?

Yes, I think so, value would be ON. I will look into it.

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-10-14 16:24:41 Re: [HACKERS] Alternative to LIMIT in SELECT ?
Previous Message Billy G. Allie 1998-10-14 15:26:47 Re: [HACKERS] PostgreSQL v6.4 BETA2 ...