Subject | Re: [firebird-support] How to use arrays? |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2013-06-30T20:27:44Z |
Hello, W!
Monday, July 1, 2013, 12:15:21 AM, you wrote:
WO> Hello
WO> Somebody knows how to use arrays?
do not use arrays, ever.
Arrays are stored "inside" blobs, so, it's simpier
to use blob for your client array data.
Because the only thing you can do in SQL/DML with arrays is selecting
array element.
Insert and update you can do only at client side, writing array as a
blob. Or, you may use embedded sql preprocessor gpre, but I think
you will not like that idea :-)
But, if you are just curious, check procedures in employee.fdb and
InterBase's documentation.
p.s. someone thinks that arrays are better than blobs, because
they can update only part of array, not the whole array.
But, this is not true - new array is written the whole, same as
if you will try to modify 1 byte in 1mb blob - 1 mb will be written.
--
Dmitry Kuzmenko, www.ib-aid.com
Monday, July 1, 2013, 12:15:21 AM, you wrote:
WO> Hello
WO> Somebody knows how to use arrays?
do not use arrays, ever.
Arrays are stored "inside" blobs, so, it's simpier
to use blob for your client array data.
Because the only thing you can do in SQL/DML with arrays is selecting
array element.
Insert and update you can do only at client side, writing array as a
blob. Or, you may use embedded sql preprocessor gpre, but I think
you will not like that idea :-)
But, if you are just curious, check procedures in employee.fdb and
InterBase's documentation.
p.s. someone thinks that arrays are better than blobs, because
they can update only part of array, not the whole array.
But, this is not true - new array is written the whole, same as
if you will try to modify 1 byte in 1mb blob - 1 mb will be written.
--
Dmitry Kuzmenko, www.ib-aid.com