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 with trellis]](http://www.bturnip.com/weblog/wp-content/uploads/2009/06/raised_bed_garden_20090601-300x225.jpg "raised_bed_garden_20090601")
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.
Gabe and I went to the park that is down by the Rivermarket- Wow!
Continue reading
It took me a while to track down the Easter pics- I still am not sure where the other memory card might be. Here’s a few of Graydon in her Easter best:
Turns out that making custom error pages is really easy:
Go ahead and try it out: [broken link]
Kind of nice, especially since everything here @ bturnip.com outside of the blog is one big broken link.
Q: When do I decide that I really do want to take my dryer apart to hopefully find and replace a broken drum belt?
Continue reading
Family hit the Clinton Library for fun and games:
Gabe and Graydie get the Easter Egg gathering pep talk from Mom and then get to it…
Continue reading
I was getting some pics of the various things blooming in the yard. I like best the flowers that bed down over the winter and come back the next year. We have a Japanese quince in the yard that puts up nice pink flowers.
I was trying to find a good camera angle to get some good shots of the blooms and saw this wasp buzzing around. He didn’t bother me and I didn’t bother him outside of a little paparazzi attention. The wasp didn’t seem to mind:
Graydie turned 1 on the 19th of this month. We waited until the weekend to have a party…
Continue reading
