2006/7/7, T E Schmitz <[EMAIL PROTECTED]>:
valid entries would be:
"28mm F2.8" (prime lens)
"30-70mm F4" (zoom lens)
"30-70mm F2.8" (zoom lens)
"30-100mm F4.5-5.6" (zoom lens with variable speed)
If these are the cases, wouldn't the regex be simply:
"^[\d\-]+mm" for BASE
"^[\d\-]+mm (.+)$" for SUFFIX
Or are you having to deal with malformatted data too (like "30 -70mm"
or "28 mm ")?
Emils
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
