Gabe and Graydie had ice cream cones and swingset time in the back yard. The ice cream served mainly to get them extra grubby really really fast, but they had fun so it was worth the cleanup.
Two more examples of regexp_like for the memory banks:
-- convert to NULL if SOME_COL is not A,B,C,1,2,or 3
case
when (regexp_like(a.SOME_COL,'[^A-C1-3]'))
then NULL
else
a.SOME_COL
end as SOME_COL,
-- convert to 0000 if the col's value is not a series of valid digits
case
when (regexp_like (a.ANOTHER_COL,'[^[:digit:]]'))
then '0000'
else
a.ANOTHER_COL
end as ANOTHER_COL,
It has been barely 3 weeks since we first [reported] plucking the first vegetable from our raised bed garden. Since then, our garden has just exploded!
Farmer’s market “Carbon” tomatoes with fresh basil from our garden in a caprese salad, flank steak from the grill, pasta and fresh vegetables seasoned with herbs from our garden. Tasty!
Visiting the Nars
correction: Elk, not deer!
Continue reading
This is the continuation of the Buffalo River posts, part 1 is [here]…
Me and my buddies took a late June trip up to the Buffalo River.
Our three day route was to take us between Mt. Hersey and Gilbert:
Continue reading
Caught an elbow reaching in trying to poke a rebound away:
Continue reading
Gabe did the honors of plucking our first garden vegetable today. We chopped up the banana pepper, it was full of fresh-from-the-garden goodness:
