SELECT FIRST (5) ....
returns rows in some random order,
is this as designed ?

SELECT FIRST (5) DISTINCT ....
returns rows according to primary key

of course

SELECT FIRST (5) .... ORDER BY PRIMARY KEY
works as expected


Hans
=====================================

raptor wrote:

>
> hi,
> I've just installed the FB1.0beta
> this works :
> SELECT FIRST (5) DISTINCT ....
>
> this doesn't :
> SELECT DISTINCT FIRST (5) ...
>
> the funny thing is that the first new feature of FB seems to work :")))...
> thanx alot ppl,
> this feature was the SELECT TOP 1 FROM myList
> =====
> iVAN
> raptor@...
> =====
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/