On Mon, Sep 7, 2009 at 11:51 PM,
Atul_Vaidya<atul.vai...@prototechsolutions.com> wrote:
>
> Hi,
>    How to store a multimap in SQlite database ?
> My requirement is that i want to store a multimap<int,long> in a column of
> the SQlite table
> Regards,
> Atul

For those who have no idea what a multimap is, it's a key:value
mapping with non-unique keys.

If you really want to store it in a single column, I would take a look
at the Boost serialization library and store it in a blob.  If you
want to actually use the multimap from SQL, or if you want to make it
more portable, you can easily use SQL types directly.

create table foo(key integer, value integer);
create index foo_keys on foo(key);

-- 
Cory Nelson
http://int64.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to