Function with blobs, how?

[Ivan Smahin]

On Sep 19, 2013, at 12:31 AM, Thomas Flemming <tf at qvgps.com> wrote:

> Hi,
> 
> how do I write a function, which retunrs a specific byte out of a blob-field?
> For example:
> 
> CREATE OR REPLACE FUNCTION MyBlob10( inValue blob) RETURNS byte
> BEGIN
>   RETURN inValue[10];
> END
> 
> This always retunrs a syntax-error after inValue in line 3 when I SqlExecute() this.
> 


Currently we have very limited set of SQL-functions to work with binary data from SQL.
Please add it to the mantis as a feature request.

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com