Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • How about keeping a window open on SQL As Understood By SQLite [sqlite.org]? expression [sqlite.org] shows that its parser expects subselects only in conjunction with IN, not =. (Is the latter even valid in SQL in general?)
    • by rjbs (4671) on 2005.04.12 13:35 (#39628) Homepage Journal
      I'll definitely keep an eye on that... but it doesn't explain why the query seemed to work as written in DBD::SQLite 1.08, which uses 3.1.3 instead of 3.0.8. 3.1.0 introduced correleated subqueries, which is what I want. The lang_expr page would, then, seem to be wrong.
      --
      rjbs