Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread LIST(DISTINCT
Sat, Dec 20 2014 10:16 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

If it doesn't screw anyone else up I'd like this changing so the distinct applies to individual values not to row values.

The reason is I store lists of various types in CLOB columns (eg user flags for contacts) and it would be useful to get a consolidated list of values that have been applied eg

say one contact has the flags

ONE
TWO
THREE

and another

ONE
SEVEN
TWELVE

currently LIST(DISTINCT flags USING #13) would give me

ONE
TWO
THREE
ONE
SEVEN
TWELVE

and I'd like to see
ONE
SEVEN
TWO
THREE
TWELVE


Roy Lambert
Tue, Dec 23 2014 8:58 AMPermanent Link

Adam Brett

Orixa Systems

Its a nice suggestion, but it would be a b*******d to run wouldn't it Roy?

Wouldn't it require in-memory parsing every CLOB of possibly a very large DB with the delimiter, turning this into a mega, mega list & sorting it. On a decent size table with lots of large CLOBs it would take bloody ages.
Wed, Dec 24 2014 3:24 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam

>Its a nice suggestion, but it would be a b*******d to run wouldn't it Roy?
>
>Wouldn't it require in-memory parsing every CLOB of possibly a very large DB with the delimiter, turning this into a mega, mega list & sorting it. On a decent size table with lots of large CLOBs it would take bloody ages.

Without knowing how Tim does it currently I have no real idea of what the impact would be, but I know there would be some. I'd be quite happy writing my own custom function (probably in Delphi) to bolt into the engine but I'm not sure what good practice would be to develop the equivalent of the LIST command.

Roy Lambert
Image