Re: SELECT substring with regex

T E Schmitz wrote:

> 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)

I think you already got all the help you needed, but I want to point out
that the Nikon 18-70mm that was used to take this picture

http://people.planetpostgresql.org/mha/index.php?/archives/97-Conference-is-over....html

seems to have a lot of aberration (I don't know the technical term,
sorry).  Notice that grid on the floor?  It looked very straight on the
real life.  I'd expect a bit of curvature but I think that's too much.

Sorry for the offtopic :-)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.