Function with blobs, how?

[Thomas Flemming]

Hi Ruslan,

 > Why exactly you want it?
I need to sort by a value, which is only in a blob.
So I was hoping to extract this in a sql-function.

But its fine. I found another solution with a temporary column.

Tom


Am 20.09.2013 11:13, schrieb Ruslan Zasukhin:
> On 9/19/13 1:29 PM, "Thomas Flemming" <tf at qvgps.com> wrote:
>
> Hi Thomas,
>
>> Hi Ivan,
>>
>>> Currently we have very limited set of SQL-functions to work with binary
>>> data  from SQL.
>>
>>
>> I need a cursor which is sorted according to specific bytes of a blob-field.
>> This is not perfect database-design, but somehow for historical reason, I cant
>> change this now.
>>
>> Can you imagine of another way?
>> Is it possible, to sort the cursor myself?
>>
>> So maybe first get the cursor unsorted:
>> cur = db.SqlSelect("select * from mytable")
>>
>> then iterate through all records, read the blob, extract this specific bytes,
>> sort myself and somehow reorder the cursor?
>>
>>
>>> Please add it to the mantis as a feature request.
>> Will you still add this to vnet 4.9?
>
> No.
>
>
> Ivan also thinks that we do not need such function in SQL.
> May be later in JavaScript as procedural language.
>
>
> Why exactly you want it?
> What task is?
>
>

-- 
/****************************************
**   Flemming Software Development CC
**   Thomas Flemming
**   PO Box 81244
**   Windhoek, Namibia
**   http://www.quovadis-gps.com
**   mail  tf at qvgps.com
**   +264 (0)81 3329923
**   +49  (0)6182 8492599
***************************************/