Function with blobs, how?

[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?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]