Re: [U2] [UV] Sorting UNIQUE

[Anthony W. Youngman]

In message <[EMAIL PROTECTED]>, Ray 
Wurlod <[EMAIL PROTECTED]> writes

Do not rely on sorted order when using SAVING UNIQUE.  Cite Murphy's Law.

Right now it seems "they" use an insert sort or similar to determine 
uniqueness.  But there's no guarantee that it will always be thus.


iirc PI correctly, that was unlikely to return a unique list if you 
selected an index.


Don't ask me why, but when I read an index from BASIC using whatever the 
call was to get a list of values (by necessity, obviously a list of 
unique keys), it seemed to return TWO sorted lists concatenated 
together.


So yes. I would never assume it to be sorted...

Cheers,
Wol
--
Anthony W. Youngman <[EMAIL PROTECTED]>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] Sorting UNIQUE

[Ray Wurlod]

Do not rely on sorted order when using SAVING UNIQUE.  Cite Murphy's Law.

Right now it seems "they" use an insert sort or similar to determine 
uniqueness.  But there's no guarantee that it will always be thus.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] Sorting UNIQUE

[Joe Walter]

Barry,

I haven't tested this to prove it out with total certainty, but IIRC
everytime I've used the saving unique clause the results have come out
sorted in either left justified alphanumeric or right justified numeric
ascending order based on whether or not the dictionary/field specified after
the saving unique clause is set to left or right justified.

joe
- Original Message - 
From: "Barry Brevik" <[EMAIL PROTECTED]>
To: "U2-users (E-mail)" 
Sent: Thursday, May 19, 2005 9:11 PM
Subject: [U2] [UV] Sorting UNIQUE


> Running UV 9.6.1.3 on Win2K.
>
> I was doing a SELECT FILENAME SAVING UNIQUE F45, again rueing how you can
> not use SSELECT or BY when SAVING UNIQUE...
>
> ...when I noticed that the resulting lists appear to be alphanumerically
> sorted in ascending order anyway!! This makes sense to me because I would
> think the logic that determines unique-ness would have to sort the data to
> make that determination.
>
> This happens to be exactly what I'm after. But, since I am putting this
code
> into programs, can I count on sorted results at all times? Is it
guaranteed?
> I can't seem to find this in documentation.
>
> TIA,
>
> Barry
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [UV] Sorting UNIQUE

[Barry Brevik]

Running UV 9.6.1.3 on Win2K.

I was doing a SELECT FILENAME SAVING UNIQUE F45, again rueing how you can
not use SSELECT or BY when SAVING UNIQUE...

...when I noticed that the resulting lists appear to be alphanumerically
sorted in ascending order anyway!! This makes sense to me because I would
think the logic that determines unique-ness would have to sort the data to
make that determination.

This happens to be exactly what I'm after. But, since I am putting this code
into programs, can I count on sorted results at all times? Is it guaranteed?
I can't seem to find this in documentation.

TIA,

Barry
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/