On Thu, Sep 22, 2011 at 4:41 PM, Fabian Groffen <[email protected]>wrote:

> On 22-09-2011 14:34:32 +0200, Lefteris wrote:
> > SAMPLE 1 will mean 1 tuple
> >
> > and
> >
> > SAMPLE 1.0 will mean 100%
> >
> > it it is an integer is number of tuples and if it is a double is the
> > fraction of the total size of results
>
> How about introducing the following "SQL-ish" syntax instead:
>
> SAMPLE 1 PERCENT
>
> (that is, no more doubles, but just optional PERCENT keyword)
>
>
I think is too much of syntactical hassle for the user. Naturally it comes
that he will write

select * from table SAMPLE 300

and will take 300 tuples

while if he writes

select * from table SAMPLE 0.3

it will mean that he wants 0.3 * #results




> _______________________________________________
> Checkin-list mailing list
> [email protected]
> http://mail.monetdb.org/mailman/listinfo/checkin-list
>
>
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list

Reply via email to