On Fri, Jun 17, 2016 at 1:37 AM, Chris Locke <ch...@chrisjlocke.co.uk> wrote:
> I fail to see what any of this has to do with sqlite. I thought this was a > mailing list for sqlite? Seeing queries (no pun intended) on sql > statements is very subjective, especially with the limited data provided by > the original poster. > Everyone will give helpful advice, but it won't stop there, and as soon as > the original poster has another query (no pun intended) which would result > in a schema change, this would have to be explained, etc. > > A specific group on SQL is required. > Perhaps so. But such a group would run into problems because it would be a case of "whose SQL?" The four "big" ones that I know of are: SQLite, PostgreSQL, Oracle, and IBM's DB2. The basics are the same, but each has their own peculiarities. I don't know what the intent of this forum really is. It is only for SQLite related "perculiarities"? Or does it include something like the OP's question which is basically "how do I do a SQLite query to get this information?" I don't really know. I also monitor the PostgreSQL forums and see this "how do I craft an SQL query to ...?" type question quite often. What is weird to me, is that someone will post such a question on the _bugs_ forums, phrasing it as "I did this SQL query and it didn't do what I expected. Please fix your product to make it work." And the reason it didn't work was because the SQL query is garbage. Ah, the ever requested "do what I need, not what I said" fix. > > Just my thoughts... > > > Chris > > -- "Pessimism is a admirable quality in an engineer. Pessimistic people check their work three times, because they're sure that something won't be right. Optimistic people check once, trust in Solis-de to keep the ship safe, then blow everyone up." "I think you're mistaking the word optimistic for inept." "They've got a similar ring to my ear." From "Star Nomad" by Lindsay Buroker: Maranatha! <>< John McKown _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users