Re: [sqlite] select userfunc(*)

2008-05-17 Thread Bradley Smith
Igor Tandetnik wrote: > "Bradley Smith" wrote: >> Igor Tandetnik wrote: >>> Bradley Smith wrote: >>>> Why does a user defined function receive zero arguments when used in >>>> the following expression? >>>> >>>>

Re: [sqlite] select userfunc(*)

2008-05-16 Thread Bradley Smith
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 >

[sqlite] select userfunc(*)

2008-05-16 Thread Bradley Smith
Why does a user defined function receive zero arguments when used in the following expression? select userfunc(*) from t; Assuming table t was created with create table t (a, b); insert into t values(1, 'first'); insert into t values(2, 'second'); Thanks, Bradley _