On Thu, Sep 10, 2009 at 8:37 AM, Jean-Denis Muys <jdm...@kleegroup.com> wrote: > Is it possible to pass all columns of a table as arguments to a function in > a implicit way?
As Igor wrote: no. > I tried this but it did not work: > > Create table studentMarks (French, English, Maths, Physics); > Insert into studentMarks values (12, 9, 15, 14); > Insert into studentMarks values (14, 13, 12, 8); > Select max(*) from studentMarks where French > 13; > > I could always iterate from my code and build an explicit argument list for > the max function, but I'm lazy and I'm intrigued... > > Is there a way to do this? Sort of. It would mean rearranging your data structure, e.g. (ID, Language, Mark). Regards, - Robert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users