"Bradley Smith" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Igor Tandetnik wrote: >> Bradley Smith wrote: >>> Why does a user defined function receive zero arguments when used in >>> the following expression? >>> >>> select userfunc(*) from t; >> >> Why would you expect otherwise? The only precedent in standard SQL >> for a syntax like this is count(*), which doesn't need any arguments. > > I expect otherwise because my understanding of SQL is that '*' refers > to all columns in the table being queried.
Only in a select statement, but not in a function invocation. > Section 7.9 of > http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt Under > Syntax Rules 3b: > > Otherwise, the <select list> "*" is equivalent to a <value > expression> sequence But you don't use the star as a select list, do you? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
