On Nov 16, 2007 4:26 AM, Stefan Schwarzer <stefan.schwarzer@xxxxxxxxxxxx> wrote: > > Hi there, > > I run an aggregation on national statistics to retrieve regional values (for > Africa, Europe, ...). Now, I want to have a global aggregation as well. The > easiest thing for my PHP/HTML procedure would be to have the global row make > appear within the regional result. So it would be something like > > name | y_2001 | y_2002 ..... > -------------------------------------------------------- > Africa | 2323 | 342323 > Europe | .... > ..... > Global | 849309 | ..... > Is there a way to substitute this with a "static" value, such as "Global"? > So, that the query still results in three columns? Sure, just include it as 'Global' Note the single, not double, quotes. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
