Hosting Provided By

Re: [GENERAL] SQL Query

From: A. Kretschmer <andreas.kretschmer(at)schollglas.com>
Date: Wed Dec 05 2007 - 07:04:06 EST

am Wed, dem 05.12.2007, um 3:46:26 -0800 mailte David Fetter folgendes:
> Use the array_accum aggregate from the docs as follows:
>
> SELECT x, array_to_string(array_accum(y),':')
> FROM your_table
> GROUP BY x;

Yes, no noubt a better solution as my new aggregat...

Andreas

-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   
http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Received on Wed Dec 5 07:05:11 2007

This message: [ Message body ]
Next message: Alvaro Herrera: "Re: [GENERAL] Moving pgstat.stat and pgstat.tmp"
Previous message: David Fetter: "Re: [GENERAL] SQL Query"
In reply to: David Fetter: "Re: [GENERAL] SQL Query"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 21:23:21 EDT