Re: GROUP BY with a string column

On Mié 28 Nov 2001 19:42, you wrote: > Can the SUM keyword in SELECT be generalized to strings? > > A tipical use for the SUM keyword is: > > SELECT column1, SUM(column2) > FROM table > GROUP BY column1 > > This works only if column2 contains numbers (and SUM is the mathematical > sum). > > What about obtain the same behaviour, when column2 contains strings (and > SUM is string concatenation)? With which database engine? -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------