Buffalo River pt. 2
July 4th, 2009 by bturnipThis is the continuation of the Buffalo River posts, part 1 is [here]…
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:

Read the rest of this entry »
Caught an elbow reaching in trying to poke a rebound away:
Read the rest of this entry »
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:

PROBLEM:
Identify records where there is non-numeric values for a particular column.
SOLUTION:
select SOME_COL
from SOME_TBL
where regexp_like (SOME_COL,'^[^[:digit:]]’)
;
Obviously this implies that maybe the field should be a NUMBER datatype to start with, but sometimes what we want, what we should have, and what we actually have are not the same thing.
Our little raised bed garden experiment is moving along nicely. The tomato plants have grown up enough to warrant some bamboo trellis support:
![raised_bed_garden_20090601 [Raised bed with trellis]](http://www.bturnip.com/weblog/wp-content/uploads/2009/06/raised_bed_garden_20090601-300x225.jpg)
raised bed with trellis
The cell phone picture doesn’t show a lot of detail, but the tomatoes are down the middle, and that is basil up front right and the tall stuff flowering in the back is garlic, with some onions inbetween.