On Thu, Sep 22, 2011 at 01:37:59PM +0200, Roberto Cornacchia wrote:
> + * A new SQL operator has been added to support sampling the
> result of a query.
> + * The syntax for sampling is:
> + * SELECT ... FROM ... WHERE ... SAMPLE s
> + *
> + * where s if is an integer greater than 1, it defines the number
> of rows to be
> + * in the sample. If s is a double between [0.0,1.0] the it refers
> to the
> + * percentage of the result to be sampled. That is if s=0.3 then
> the sample
> + * will be 30% the size of the query result.
>
>
> Does this mean that it is not possible to select 1 random tuple?
> ("SAMPLE 1" would mean 100%) no 1 is a natural number not a decimal. Decimals between 0.0 and 1.0 are used for 'percentage'. Niels > > Roberto > _______________________________________________ > Checkin-list mailing list > [email protected] > http://mail.monetdb.org/mailman/listinfo/checkin-list -- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:[email protected] url: http://www.cwi.nl/~niels e-mail: [email protected]
pgpA9kiwCoppd.pgp
Description: PGP signature
_______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
