Short answer, Yes.
Long answer, have you read the SQLite documents?
Gerry
On Feb 13, 2016 8:13 PM, wrote:
> Hi,
>
> Is it possible to create a temporary table in SQLite so that it will only
> be
> visible to the current session and be destroyed after the session is
> closed?
> Just like SQL Ser
On 2016/02/12 6:38 PM, Michele Pradella wrote:
> Already solved with UNION of SELECT
>
It isn't solved, it is circumvented by trial and error without
understanding why.
I'm sure that works ok for you in this case, but the point is if you do
study those documents a bit more, you may grasp the
On 2016/02/13 6:52 AM, J Decker wrote:
> On Fri, Feb 12, 2016 at 8:00 PM, Igor Tandetnik wrote:
>> On 2/12/2016 10:44 PM, J Decker wrote:
>>>
>>> I expect it to take any string
>>
>> What is the basis of this expectation, other than wishful thinking?
> I don't think expectation and wishful thin
>The result is correct.
I am so surprized by your assertion I am sure there is some
misunderstanding. The way 1) is performed, scan song_artist first, is
suboptimal. Try my example with ~8000 rows and a where clause that returns
multiple songs and you will see what I mean.
>This would not necess
4 matches
Mail list logo