Subject | ORDER BY on BLOB |
---|---|
Author | Kenneth Foo |
Post date | 2002-03-31T05:14:49Z |
Hi
Is sorting by contents of text blobs possible on IB/FB?
I tried something like this
select * from messages order by msg_from;
where msg_from is a blob field subtype 1. (Text).
What I got was totally off.
Is IB/FB sorting against BLOB ID instead?
If yes, how then do I sort by BLOB contents?
Regards
Kenneth
[Non-text portions of this message have been removed]
Is sorting by contents of text blobs possible on IB/FB?
I tried something like this
select * from messages order by msg_from;
where msg_from is a blob field subtype 1. (Text).
What I got was totally off.
Is IB/FB sorting against BLOB ID instead?
If yes, how then do I sort by BLOB contents?
Regards
Kenneth
[Non-text portions of this message have been removed]