[MonetDB-users] Arrays or BATs as SQL column?
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Is there currently any possibility to store arrays or full BATs in a MonetDB5/SQL column which can be referenced later on? I'm looking for a support "database native" serialisation. Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAlAAGyUACgkQYH1+F2Rqwn0mgwCdEBGeN+ULO0wH3nOG5SVhuna8 OqwAniKRa9qq6pr5pUnr90m+9MtlWbtH =XLkD -----END PGP SIGNATURE-----
On 13-07-2012 14:57:09 +0200, Stefan de Konink wrote:
Is there currently any possibility to store arrays or full BATs in a MonetDB5/SQL column which can be referenced later on? I'm looking for a support "database native" serialisation.
An SQL column IS a BAT, so what do you mean? Fabian
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 On 13-07-12 15:07, Fabian Groffen wrote:
On 13-07-2012 14:57:09 +0200, Stefan de Konink wrote:
Is there currently any possibility to store arrays or full BATs in a MonetDB5/SQL column which can be referenced later on? I'm looking for a support "database native" serialisation.
An SQL column IS a BAT, so what do you mean?
create table test (id serial, objects BAT); Or regarding to PostgreSQL syntax: create table test (id serial, objects integer[]); As you state in MonetDB a column is a BAT. Is there any exported variable width datatype that hosts BAT columns in itself? Giving each row in the first column an unique BAT. Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAlAAIgAACgkQYH1+F2Rqwn11iACfRyegaB/ZqXDi9urv3gL8BaoO hv8AoIZEoP3KuEAI+FQnBZLunV3yIyTN =2mnJ -----END PGP SIGNATURE-----
On 13-07-2012 15:26:24 +0200, Stefan de Konink wrote:
On 13-07-12 15:07, Fabian Groffen wrote:
On 13-07-2012 14:57:09 +0200, Stefan de Konink wrote:
Is there currently any possibility to store arrays or full BATs in a MonetDB5/SQL column which can be referenced later on? I'm looking for a support "database native" serialisation.
An SQL column IS a BAT, so what do you mean?
create table test (id serial, objects BAT);
Or regarding to PostgreSQL syntax:
create table test (id serial, objects integer[]);
As you state in MonetDB a column is a BAT. Is there any exported variable width datatype that hosts BAT columns in itself? Giving each row in the first column an unique BAT.
You want a BAT in a BAT. No. Fabian
participants (2)
-
Fabian Groffen -
Stefan de Konink