pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Huxton <dev@archonet.com>
To: Philippe Lang <philippe.lang@attiksystem.ch>
To: pgsql-sql@postgresql.org
Subject: Re: crosstabs
Date: Thu, 19 Feb 2004 17:26:48 +0000
Message-ID: <200402191726.48545.dev@archonet.com> (raw)
In-Reply-To: <6C0CF58A187DA5479245E0830AF84F420AFC0E@poweredge.attiksystem.ch>
References: <6C0CF58A187DA5479245E0830AF84F420AFC0E@poweredge.attiksystem.ch>

On Thursday 19 February 2004 16:02, Philippe Lang wrote:
> Hello,
>
> I need to do something similar to a cross tabulation, but without any
> aggregation.

Have a look in the contrib/ folder of the source distro (or your contrib 
package). There are some set-returning tablefunc examples. Also you might 
want to look at the excellent set-returning function article on 
http://techdocs.postgresql.org/

-- 
  Richard Huxton
  Archonet Ltd



view thread (6+ messages)  latest in thread

Message-ID: <200402191726.48545.dev@archonet.com>
Permalink:  ../200402191726.48545.dev@archonet.com/
Also on:    postgresql.org/message-id/200402191726.48545.dev@archonet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dev@archonet.com, philippe.lang@attiksystem.ch
  Subject: Re: crosstabs
  In-Reply-To: <200402191726.48545.dev@archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox