Subject Re: [ib-support] Substring Function
Author Helen Borrie
At 12:25 PM 23-04-02 +1200, Sandeep wrote:
>Where can I get the list of all functions in firebird?

In the release notes. You should read them, as select first has some
undesirable (nay, catastrophic) effects if you use it thoughtlessly with

>Why doesn't
> select substring (fieldA from 0 for 2) from tableA
>work? I get exception [Positive value expected]

Because the dataset doesn't have a "row 0". It will either have no rows or
it will have one or more. Positive means "non-zero and non-negative".

fieldA from 1 for 2 will capture the first two rows.


All for Open and Open for All
Firebird Open SQL Database · ·