> SELECT POSITION(cast(ascii_char(1) AS BLOB SUB_TYPE BINARY),
> CAST(x'0001' as blob sub_type binary)) FROM rdb$database;
Nice. Thanks. It even looks like I don't need the first CAST.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://
On 23/02/2021 10:37, Jiří Činčura wrote:
> Or maybe not. Any smart way to make something like this work? Maybe I just
> don't see it.
>
> SELECT POSITION(CAST(CAST(1 AS SMALLINT) AS BLOB SUB_TYPE BINARY),
> CAST(x'0001' as blob sub_type binary)) FROM rdb$database
>
> The `CAST(1 AS SMALLINT)` i
On 23-02-2021 14:37, Jiří Činčura wrote:
Or maybe not. Any smart way to make something like this work? Maybe I just
don't see it.
SELECT POSITION(CAST(CAST(1 AS SMALLINT) AS BLOB SUB_TYPE BINARY), CAST(x'0001'
as blob sub_type binary)) FROM rdb$database
The `CAST(1 AS SMALLINT)` is, at the mo
Or maybe not. Any smart way to make something like this work? Maybe I just
don't see it.
SELECT POSITION(CAST(CAST(1 AS SMALLINT) AS BLOB SUB_TYPE BINARY), CAST(x'0001'
as blob sub_type binary)) FROM rdb$database
The `CAST(1 AS SMALLINT)` is, at the moment constant byte value I'm getting
(henc
Ah, there's my problem. With little bit of casting I think I can make it work.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 2021-02-23 10:27, Jiří Činčura wrote:
Hi *,
is there a reason why POSITION does not work on binary blobs? I would
expect something like `POSITION(blob, 0x1)` to work.
Did you mean POSITION(blob, x'01'), because I wouldn't expect 0x1 (an
integer literal) to work.
In any case, the problem
Hi *,
is there a reason why POSITION does not work on binary blobs? I would expect
something like `POSITION(blob, 0x1)` to work.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel