Name
aref — returns specific element of an array or string
Synopsis
aref
(
|
arg any , |
nth
integer
); |
Description
aref returns the nth element
of an array, string or
string_session, where nth is a
zero-based index. If the first argument is a string or
string_session, the integer ASCII value of the
nth character is returned. If the first argument is
an array of any, then the corresponding element is returned.
Parameters
arg
array, vector or string.
nth
integer zero-based index.
Return Values
An integer character code or nth
element as whatever type the element is if arg is
an array or vector (heterogeneous array.)
Errors
Table 24.2. Errors signalled by aref
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
| 22003 | SR017 | aref: Bad array subscript (zero-based) %d for an arg of type %s (%d) and length %d. | |
| 22023 | SR000 | aref expects an array or vector, not an arg of type %d. |
Examples
Example 24.13. Simple examples
SQL> select aref ('Abacus', 0);
callret
VARCHAR
_______________________________________________________________________________
65
1 Rows. -- 3 msec.
SQL> select aref (vector ('Primero', 2, 3.333), 2);
callret
VARCHAR
_______________________________________________________________________________
3.333
1 Rows. -- 4 msec.
SQL>