boatswain

joined 2 years ago
[–] boatswain 1 points 1 month ago (1 children)

This is the opposite of bag holding though, isn't it? Since it's an expanded offering to sell?

[–] boatswain 4 points 1 month ago

He got it right (which makes sense; he coined the term); OP didn't.

[–] boatswain 3 points 1 month ago

I am aware, but the person I'm replying to mentioned a specific device, which I also have.

[–] boatswain 4 points 1 month ago
[–] boatswain 8 points 1 month ago (5 children)

Where was it? Haven't find it on mine

[–] boatswain 6 points 1 month ago

It says right there in the thumbnail: it's mm-wave radio. They're radios that talk to each other and form a mesh network.

[–] boatswain 3 points 1 month ago (1 children)

Another satisfied Framework user here, wondering what kind of struggles you've been facing; I haven't had any problems at all.

[–] boatswain 7 points 1 month ago (1 children)

Sauerkraut is apparently a reasonable way to store vitamin C for a long time. I imagine cabbage in its own doesn't keep too well.

[–] boatswain 21 points 1 month ago (1 children)

I've only ever seen Chile as the country.

[–] boatswain 1 points 1 month ago (1 children)

I really didn't think that's correct--though it's been a few years since I did SQL regularly.

SELECT *
FROM articles
WHERE last_updated >= %s
  AND created_at IS NOT NULL
UNION
SELECT *
FROM articles
WHERE id IN (1, 2, 3)
  AND created_at IS NOT NULL

That should give a list of all articles updated after whatever date (regardless of ID), appended to a list of all articles where the ID is 1, 2, or 3 (regardless of when they were last updated). I would expect to see extra articles that only fit one criteria or the other, and also duplicate articles.

I included the join quote because an inner join would be the way to do this, rather than a union--though it would likely be less efficient than just filtering on the required parameters.

If I'm wrong here, I'd love an explanation of why.

[–] boatswain 2 points 1 month ago (3 children)

UNION is used to append the result of one query to the result of another: https://learn.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union-transact-sql?view=sql-server-ver17

A UNION concatenates result sets from two queries. But a UNION does not create individual rows from columns gathered from two tables. A JOIN compares columns from two tables, to create result rows composed of columns from two tables.

Your two queries are not equivalent.

[–] boatswain 5 points 1 month ago

Sure seems to be. I see it advertised here and there pretty often.

view more: ‹ prev next ›