--- Christoph Haller <[EMAIL PROTECTED]> wrote: > It's obvious this approach is most inflexible. > As soon as there is a new vendor, one has to > re-write the query and add > SUM(CASE vendor WHEN 'mr. new' THEN ... , >
> In an advanced example it is shown how to deal with > cross tabs in > general > using a stored procedure. I am going to translate > this and re-write it > for postgres, too (ok, I will try). I saw something that might somewhat a bit more flexible solution using SQL. I don't know it it work in PostgreSQL. I saw it at the MySQL site. The following is the URL: http://www.mysql.com/articles/wizard/index.html Has anyone tried this on a PostgreSQL database ? regards, ludwig __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
