From: | David Eduardo Gomez Noguera <davidgn(at)servidor(dot)unam(dot)mx> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | aggregate functions only for numbers? |
Date: | 2002-02-08 04:40:04 |
Message-ID: | 20020207224004.52db77a6.davidgn@servidor.unam.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello
I was making a reay dumb database.
just to play.
Its an agenda. I set 2 tables thus far, one for people with unique attribs to each people (birth, address and the like) and one for phones, since some people have more than one, or cell phones, etc.
I wanted to make a query of name,birth date and phones, and have them grouped by name (so the name appeared only once) to get something like
somebody |xxx-yyyy| mm-dd-yyyy
|xxx-yyyy|
somebody |xxx-yyyy| mm-dd-yyyy
else | |
But i guess its not possible right now?
I did install the headers too, so i was just wondering if i could write an aggregate function to concatenate any type. In the docs, its not listed, and there are only aggregate functions that opperate on numbers.
If you can point me as to where to start looking to do some coding server side on it, i would appreciate that.
--
ICQ: 15605359 Bicho
=^..^=
First, they ignore you. Then they laugh at you. Then they fight you. Then you win. Mahatma Gandhi.
........Por que no pensaran los hombres como los animales? Pink Panther........
-------------------------------気検体の一致------------------------------------
暑さ寒さも彼岸まで。
アン アン アン とっても大好き
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-02-08 05:11:01 | Re: aggregate functions only for numbers? |
Previous Message | Lincoln Yeoh | 2002-02-08 03:35:31 | Re: Threaded PosgreSQL server |