On Fri, Nov 28, 2014 at 6:26 PM, Richard Hipp <d...@sqlite.org> wrote:
> Such a virtual table is now on trunk:
>
> CREATE VIRTUAL TABLE temp.x USING files_of_checkin;
> SELECT * FROM x WHERE checkinID=?;
>
OMG. It would have taken me a week to do that.
> The checkinID is the numeric "RID" of the checkin for which you want a
> listing of files. A WHERE clause term of the form checkinID=? is required.
>
If there are no objections i'll add the SQL function sym2rid() which works
like symbolic_name_to_rid(). Then the above becomes: ... WHERE
checkinID=sym2rid('trunk'); i thought we already had such a function, but
don't see it.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
fossil-dev mailing list
fossil-dev@lists.fossil-scm.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/fossil-dev
