Thank you everyone for your kind input and suggestions. That is quite a lot to consider. I didn't realize it would be so difficult for a Select statement to return a string.
Out of curiosity, when I do: SELECT * FROM Person WHERE id IN(2,2,3,3) It doesn't seem to give back 4 rows, only 2. Looks like the duplicates are not being returned. Is there someway to get back all 4 rows. On 5/22/14, Keith Medcalf [via SQLite] <[email protected]> wrote: > > > Andy Goth wrote: > >>And honestly, please don't give people with no knowledge of >>SQL theory the power to set your SQL schema in stone. > > I am sure you mean Relational Theory, when using a database implementing > Relational semantics, such as SQLite. > > There is no requirement that SQL (Structured Query Language) be implemented > to query a Relational Database. There are many implementations which use > SQL to query data from hierarchical, network, network extended, and a myriad > of other underlying database storage mechanisms. SQL no more binds the > relational model than using COBOL (a computer programming language) binds > the implementation to a 4341 SysPlex running OS/VS1. > > SQLite implements an SQL interface using a relational access model against > an ISAM datastore. Storing mutivalued (array) items is a violation of the > Relational Model, not SQL and not ISAM. If you used, for example, ADABAS, > then you could store arrays in a table field and perform SQL operations > against them as if they were a BCNF normalized relational N:M join table. > Some other not-so-relational relational databases support nonstandard means > of achieving the same thing. > > > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > If you reply to this email, your message will be added to the discussion > below: > http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75767.html > > To unsubscribe from Simple Select from IN - from a newbie., visit > http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=75751&code=ZmFudGFzaWEuZG9zYUBnbWFpbC5jb218NzU3NTF8MTk4Njk4NTgwNw== -- View this message in context: http://sqlite.1065341.n5.nabble.com/Simple-Select-from-IN-from-a-newbie-tp75751p75769.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
