SUBSTRB

[zyl6628156]

`
-- oracle

SQL> SELECT SUBSTRB('aaabbbccc',-4,1) FROM DUAL;

S

b

SQL> SELECT SUBSTRB('aaabbbccc',-4,2) FROM DUAL;

SU

bc

SQL> SELECT SUBSTRB('aaabbbccc',-4,3) FROM DUAL;

SUB

bcc

SQL> SELECT SUBSTRB('aaabbbccc',-4,6) FROM DUAL;

SUBS

bccc

-- orafce 3.18

postgres=# SELECT SUBSTRB('aaabbbccc',-4,1) FROM DUAL;
substrb

(1 row)

postgres=# SELECT SUBSTRB('aaabbbccc',-4,2) FROM DUAL;
substrb

(1 row)

postgres=# SELECT SUBSTRB('aaabbbccc',-4,3) FROM DUAL;
substrb

(1 row)

postgres=# SELECT SUBSTRB('aaabbbccc',-4,6) FROM DUAL;
substrb

a
(1 row)

`

[okbob]

The substrb call is forward to call PostgreSQL bytea_substr function now. These functions doesn't support negative arguments. I'll try to fix it.

[okbob]

It should be fixed in master branch - see last commit 7206c10

[zyl6628156]

thanks