No. The internal table stores only unique keys. -----Ursprüngliche Nachricht----- Von: Humblebee [mailto:[email protected]] Gesendet: Donnerstag, 22. Mai 2014 11:39 An: [email protected] Betreff: Re: [sqlite] Simple Select from IN - from a newbie.
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-newbi > e-tp75751p75767.html > > To unsubscribe from Simple Select from IN - from a newbie., visit > http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=uns > ubscribe_by_code&node=75751&code=ZmFudGFzaWEuZG9zYUBnbWFpbC5jb218NzU3N > TF8MTk4Njk4NTgwNw== -- 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 ----------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: [email protected] This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
