In lieu of adding the syntactic sugar, might it be worth documenting the
alternative(s)? Currently the docs for these are
"https://sqlite.org/omitted.html"; - which simply says: "LEFT OUTER JOIN is
implemented, but not RIGHT OUTER JOIN or FULL OUTER JOIN."
A couple of lines saying why this isn't
On 6 Dec 2017, at 6:07pm, R Smith wrote:
> You mean make SQLite less Lite, but with Zero computational advantage, by
> simply adding syntactic sugar bloat? - I'm going to have to vote No on that.
> (Luckily my vote counts extremely little.)
I would normally vote with you, but …
> I think the
On 2017/12/06 6:35 PM, Christian Schmitz wrote:
Actually, the left outer join is sufficient to execute all the outer
join operators:
- right outer join: just swap the "from" arguments
- full outer joins: union of left and right outer joins
Couldn’t SQLite implement that and do the swap for u
>>
>>> Actually, the left outer join is sufficient to execute all the outer
>> join operators:
>>>
>>> - right outer join: just swap the "from" arguments
>>>
>>> - full outer joins: union of left and right outer joins
>>
Couldn’t SQLite implement that and do the swap for us?
As well as the un
Thanks all for the input. My knowledge from nearly 20 years ago is a bit
rusty when it came to material like this. Just adding "LEFT JOIN" instead
of just "JOIN" has my query working as I need it to. This type of result
set isn't something I regularly perform.
On Wed, Dec 6, 2017 at 4:41 AM, S
On 6 Dec 2017, at 9:36am, Jean-Luc Hainaut wrote:
> Actually, the left outer join is sufficient to execute all the outer join
> operators:
>
> - right outer join: just swap the "from" arguments
>
> - full outer joins: union of left and right outer joins
I never realised that. It’s clever. A
Actually, the left outer join is sufficient to execute all the outer
join operators:
- right outer join: just swap the "from" arguments
- full outer joins: union of left and right outer joins
Examples (classical "supplier-part-supply" example):
create table S(SN,NAME);
create table P(PN,COL
;Sent: Tuesday, 5 December, 2017 14:45
>To: General Discussion of SQLite Database
>Subject: [sqlite] Emulate right-join
>
>I'm working on a pretty simplified event tracking system (So I stay
>out of
>trouble of not updating time spent throughout the day), and each item
>that
>I
On Tue, Dec 5, 2017 at 3:44 PM, Stephen Chrzanowski
wrote:
> I'm working on a pretty simplified event tracking system (So I stay out of
> trouble of not updating time spent throughout the day), and each item that
> I need to track has an associated priority with it, which ranges for any
> positiv
I'm working on a pretty simplified event tracking system (So I stay out of
trouble of not updating time spent throughout the day), and each item that
I need to track has an associated priority with it, which ranges for any
positive integer value. This priority can be user defined as a positive
int
10 matches
Mail list logo
