On Mon, Sep 05, 2005 at 16:19:28 +0200,
Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Am Montag, 5. September 2005 15:57 schrieb Aldor:
> > I want to get out a string only with characters A-Za-z.
> > Any idea how to do this in Postgres with POSIX Regex?
>
> Presumably,
>
> colname ~ '^[A-Za
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Am Montag, 5. September 2005 17:40 schrieb Harald Fuchs:
>> I dunno the details of the supported encodings, but is there
>> any encoding where 'a-z' includes more or less than 26 letters?
> Well, it seems that our regexp library interprets [a-z] as e
Am Montag, 5. September 2005 17:40 schrieb Harald Fuchs:
> How so? I thought character ranges are more an encoding than a locale
> issue.
That is incorrect.
> I dunno the details of the supported encodings, but is there
> any encoding where 'a-z' includes more or less than 26 letters?
Well, it
Am Montag, 5. September 2005 17:13 schrieb Alvaro Herrera:
> Note that [:alpha:] and such character classes are defined by POSIX to
> be locale independent:
>
> alvherre=# select 'á' ~ '[a-z]';
> ?column?
> --
> f
> (1 fila)
>
> alvherre=# select 'á' ~ '[[:alpha:]]';
> ?column?
> ---
In article <[EMAIL PROTECTED]>,
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Presumably,
> colname ~ '^[A-Za-z]*$'
> If you want to be independent of locale issues, then you'd have to enumerate
> all the letters instead of using a range specification.
How so? I thought character ranges
Am Montag, 5. September 2005 17:10 schrieb A. Kretschmer:
> > colname ~ '^[A-Za-z]*$'
>
> This match also a empty string.
An empty string also fulfulls the condition "only with characters A-Za-z". Or
maybe not. :-)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
On Mon, Sep 05, 2005 at 04:19:28PM +0200, Peter Eisentraut wrote:
> Am Montag, 5. September 2005 15:57 schrieb Aldor:
> > I want to get out a string only with characters A-Za-z.
> > Any idea how to do this in Postgres with POSIX Regex?
>
> Presumably,
>
> colname ~ '^[A-Za-z]*$'
>
> If you w
am 05.09.2005, um 16:19:28 +0200 mailte Peter Eisentraut folgendes:
> Am Montag, 5. September 2005 15:57 schrieb Aldor:
> > I want to get out a string only with characters A-Za-z.
> > Any idea how to do this in Postgres with POSIX Regex?
>
> Presumably,
>
> colname ~ '^[A-Za-z]*$'
Am Montag, 5. September 2005 15:57 schrieb Aldor:
> I want to get out a string only with characters A-Za-z.
> Any idea how to do this in Postgres with POSIX Regex?
Presumably,
colname ~ '^[A-Za-z]*$'
If you want to be independent of locale issues, then you'd have to enumerate
all the letter
On Mon, Sep 05, 2005 at 02:57:06PM +0100, Aldor wrote:
>
> I want to get out a string only with characters A-Za-z.
>
> I tried really a lot of things with substring and read many POSIX docs,
> I'm also familiar with the Perl RegEx but right now, I'm giving up... ;-(
>
> Any idea how to do this i
am 05.09.2005, um 14:57:06 +0100 mailte Aldor folgendes:
> Hi,
>
> I want to get out a string only with characters A-Za-z.
like this?
test=# select * from foo;
s
123
abz
abz123
(3 rows)
test=# select * from foo where s ~ '^[a-zA-Z]+$';
s
-
abz
(1 row)
> Any idea how to
Hi,
I want to get out a string only with characters A-Za-z.
I tried really a lot of things with substring and read many POSIX docs,
I'm also familiar with the Perl RegEx but right now, I'm giving up... ;-(
Any idea how to do this in Postgres with POSIX Regex?
Regards,
Aldor
--
12 matches
Mail list logo