On 12/20/2012 4:10 PM, Larry Brasfield wrote:
> Igor Tandetnik wrote:
>>>> [regarding where parameters allowed, "where literals are"]
>> >
>> > How did you discern this?
>>
>> I know from experience where parameters work (SELECT, INSERT and
>> similar; also ATTACH as one of my projects happens to use it this way),
>> and where they don't (all forms of CREATE; I haven't tried ALTER but I'm
>> 99% sure it won't work there either). I've just tested PRAGMA. I briefly
>> scanned the rest at http://sqlite.org/lang.html to confirm that their
>> syntax doesn't involve expressions.
>
> I do not mean to be argumentative here, but I think the documentation on
> this leads to a different result. If you examine the syntax diagram for
> "create view"
Why should I? I never made any claim about CREATE VIEW's syntax. In my
explanation, "All forms of CREATE", which includes CREATE VIEW, fall
under "know from experience" bucket, not "syntax doesn't involve
expressions" bucket.
You assert (believably) that SQLite has not allowed parameters in views
for awhile, and that you know this from experience rather than the
documentation. I assert (without refutation) that the documentation
clearly allows parameters in a view. We have no disagreement, but it
does appear that SQLite's operation differs from what its documentation
clearly implies. Hence my revision of the topic.
I will not suggest that you should be interested in this discrepancy,
but others might be.
Best regards,
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
