Re: Problemas usando like

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Marcos Saldivar <baron(dot)rojo(dot)cuerdas(dot)de(dot)acero(at)gmail(dot)com>
Cc: "Roberto A(dot)" <gedeon56(at)gmail(dot)com>, pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Problemas usando like
Date: 2008-11-12 00:47:13
Message-ID: 20081112004713.GQ4272@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Marcos Saldivar escribió:
> 2008/11/11 Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>:

> un: select '1.234.567-A' ~ ('[1-4]' || E'\\.' || '[0-9]{3}' || E'\\.'
> || '[0-9]{3}-[a-zA-Z]');
>
> no existirá algo menos complejo que esa expresión ???

select '1.234.567-A' ~ (E'[1-4]\\.[0-9]{3}\\.[0-9]{3}-[a-zA-Z]');

--
Alvaro Herrera Valdivia, Chile Geotag: -39,815 -73,257
"World domination is proceeding according to plan" (Andrew Morton)

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2008-11-12 00:49:49 Re: Argentina PUG
Previous Message Fabian Sandoval 2008-11-12 00:36:39 Re: Problema con Copy to delimiter