A. Kretschmer escribió:
am Thu, dem 21.06.2007, um 12:59:05 +0200 mailte Dani Castaños folgendes:
change the generate_series(65,90) to generate_series(32,90)
Andreas
With only changing 65 to 32:
ERROR: invalid regular expression: parentheses () not balanced
I think, it could
am Thu, dem 21.06.2007, um 12:59:05 +0200 mailte Dani Castaños folgendes:
> >change the generate_series(65,90) to generate_series(32,90)
> >
> >
> >Andreas
> >
> With only changing 65 to 32:
>
> ERROR: invalid regular expression: parentheses () not balanced
>
> I think, it could be a problem
am Thu, dem 21.06.2007, um 12:42:52 +0200 mailte Dani Castaños folgendes:
test=*# select chr(x), count(1) from generate_series(65,90) x, w where
upper(substring (w.t from 1 for 1)) ~ chr(x) group by 1;
chr | count
-+---
T | 1
B | 1
F | 2
(3 rows)
Andreas
am Thu, dem 21.06.2007, um 12:42:52 +0200 mailte Dani Castaños folgendes:
> >test=*# select chr(x), count(1) from generate_series(65,90) x, w where
> >upper(substring (w.t from 1 for 1)) ~ chr(x) group by 1;
> > chr | count
> >-+---
> > T | 1
> > B | 1
> > F | 2
> >(3 row
Hi!
I'm trying to build a query to get if there is an occurrence for a field
for each alphabetical letter.
My first thought to know it was to do something like:
SELECT COUNT(field) FROM table WHERE UPPER( field ) LIKE UPPER( 'A%' )
LIMIT 1;
SELECT COUNT(field) FROM table WHERE UPPER( field
am Thu, dem 21.06.2007, um 11:10:02 +0200 mailte Dani Castaños folgendes:
> Hi!
>
> I'm trying to build a query to get if there is an occurrence for a field
> for each alphabetical letter.
> My first thought to know it was to do something like:
>
> SELECT COUNT(field) FROM table WHERE UPPER( fi
Hi!
I'm trying to build a query to get if there is an occurrence for a field
for each alphabetical letter.
My first thought to know it was to do something like:
SELECT COUNT(field) FROM table WHERE UPPER( field ) LIKE UPPER( 'A%' )
LIMIT 1;
SELECT COUNT(field) FROM table WHERE UPPER( field )