X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AB0EB9FB27B for ; Mon, 10 Jul 2006 15:29:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 41867-08 for ; Mon, 10 Jul 2006 15:29:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx3.surnet.cl (mx3.surnet.cl [216.155.73.182]) by postgresql.org (Postfix) with ESMTP id 821C69FB259 for ; Mon, 10 Jul 2006 15:29:48 -0300 (ADT) Received: from 201-221-221-58.bk12-dsl.surnet.cl (HELO alvh.no-ip.org) ([201.221.221.58]) by mx3.surnet.cl with ESMTP; 10 Jul 2006 14:29:47 -0400 X-IronPort-AV: i="4.06,225,1149480000"; d="scan'208"; a="25031422:sNHT19645888" Received: by alvh.no-ip.org (Postfix, from userid 1000) id EA65FC5CDB7; Mon, 10 Jul 2006 14:29:44 -0400 (CLT) Date: Mon, 10 Jul 2006 14:29:44 -0400 From: Alvaro Herrera To: T E Schmitz Cc: pgsql-sql@postgresql.org Subject: Re: SELECT substring with regex Message-ID: <20060710182944.GB26570@surnet.cl> Mail-Followup-To: T E Schmitz , pgsql-sql@postgresql.org References: <44AE66E0.1040606@numerixtechnology.de> <200607071659.14940.gary.stainburn@ringways.co.uk> <44AE9B4F.1020401@numerixtechnology.de> <44AEAED9.7080300@myemma.com> <44AEC8C5.80103@numerixtechnology.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <44AEC8C5.80103@numerixtechnology.de> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/157 X-Sequence-Number: 25731 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.