On Mon, May 18, 2009 at 7:53 PM, Pavel Ivanov <paiva...@gmail.com> wrote: > Actually I wanted to know if it can be useful somewhere. :-)
You could have a calculator command on your application and let SQLite parse the result for you ;-) sqlite> SELECT 1+2*(3+4*5); 47 Regards, ~Nuno Lucas > > Pavel > > On Mon, May 18, 2009 at 2:52 PM, Noah Hart <n...@lipmantpa.com> wrote: >> Just because the syntax allows it, doesn't mean that it will be useful >> >> SELECT '1', sqlite_version() as A where A < 'a' group by 1 order by 1 >> >> Noah >> >> -----Original Message----- >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov >> Sent: Monday, May 18, 2009 11:37 AM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] error in documentation of SELECT? >> >> I didn't notice it earlier and now I'm a bit surprised. Can I ask a >> more elaborate example which will include WHERE and/or GROUP BY but >> not include FROM? >> >> Pavel >> >> >> >> >> CONFIDENTIALITY NOTICE: >> This message may contain confidential and/or privileged information. If you >> are not the addressee or authorized to receive this for the addressee, you >> must not use, copy, disclose, or take any action based on this message or >> any information herein. If you have received this message in error, please >> advise the sender immediately by reply e-mail and delete this message. Thank >> you for your cooperation. >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users