From: | "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Concatenation through SQL |
Date: | 2007-12-21 12:31:14 |
Message-ID: | 200712211331.14239.leif@solumslekt.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Friday 21. December 2007, Niklas Johansson wrote:
>select array_to_string(array[given, patronym, toponym], ' ') from
>persons where person_id=57;
>
>Notice the use of the array[] constructor, instead of the array()
>constructor, which must be fed a subquery which returns only one
> column.
Aah, great!
pgslekt=> select array_to_string(array[given, patronym, toponym], ' ')
from persons where person_id=57;
array_to_string
--------------------------
Abraham Jonsen Bjørntvet
(1 row)
Tackar och bockar!
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/
From | Date | Subject | |
---|---|---|---|
Next Message | Philippe Lang | 2007-12-21 13:48:55 | Re: Concatenation through SQL |
Previous Message | Niklas Johansson | 2007-12-21 12:07:00 | Re: Concatenation through SQL |