> I am using postgres 7.1.3
> on redhat 7.2.
First, please consider upgrading. 7.2.1 has a lot of enhancements
over 7.1.3, and we're testing 7.3.0 now!
> drop view wm_ups_count;
> create view wm_ups_count as
> substring(phase from 1 for 1) as ups,
> count(substring(phase from 1 for 1)) as phas_count
> sys_key = 10
> group by
This is your problem. It should be:
GROUP BY sys_key, substring(phase from 1 for 1);
If you GROUP BY something other than the columns you are displaying,
you will often see "duplicate" rows.
______AGLIO DATABASE SOLUTIONS___________________________
In response to
pgsql-novice by date
|Next:||From: Duncan Adams (DNS)||Date: 2002-09-10 15:39:37|
|Subject: Re: Problems with substring |
|Previous:||From: Terry Yapt||Date: 2002-09-10 15:32:04|
|Subject: pl/pgsql and returns timestamp type|