MySQL Forums
Forum List  »  Newbie

Support for vectors
Posted by: Daniel Feiglin
Date: August 25, 2004 05:39AM

I need to do something like this:

create table cards (
< some unique id stuff>
count int, # 0 - 99
results int[] # All 0 - 99 Permitted syntax under PostgreSQL

Other than stuffing a varchar with two byte ascii numbers (or similar) is there some kind of array syntax in MySQL version 4.0.18 or higher?

If not, does anyone know if support for arrays is even planned?

1. Apropos the app, it's not practicable to create records, each having one integer result, as someone has already suggested. The table is a fairly volatile transaction file with entries going in and out all the time. As it is there will be 10's of 1000's of these records floating around, so a neat solution is needed.
2. SQL conformance and all that - I don't care. It's got to work.

Options: ReplyQuote

Written By
Support for vectors
August 25, 2004 05:39AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.