> I saw something that might somewhat a bit more
> flexible solution using SQL. I don't know if it works
> in PostgreSQL. I saw it at the MySQL site.
> The following is the URL:
> Has anyone tried this on a PostgreSQL database ?
No, not me.
But as far as I can tell the SQL statements can quite easily
be re-written in PostgreSQL:
mysql> SELECT location, SUM(IF(gender='M',1,0)) AS M,
SUM(IF(gender='F',1,0)) AS F
-> FROM locations INNER JOIN employees USING (loc_code) GROUP BY
SUM(CASE WHEN gender='M' THEN 1 ELSE 0 END) AS "M",
SUM(CASE WHEN gender='F' THEN 1 ELSE 0 END) AS "F",
FROM locations LEFT JOIN employees ON
GROUP BY location;
And this goes for the perl script as well.
pgsql-sql by date
|Next:||From: Christoph Haller||Date: 2002-11-11 15:55:45|
|Subject: Generating a cross tab II (pivot table)|
|Previous:||From: Carlos Sousa||Date: 2002-11-11 14:57:34|
|Subject: bigger problem|