On Wed, Mar 19, 2008 at 03:05:06PM +0100, Ondřej Fafejta wrote:
> Hi!
>
> Postgresql: version 8.1.11
>
> Is there a way to concatenate two arrays without duplicity?
>
> This select return duplicity:
>
> SELECT array_cat(ARRAY[1,2], ARRAY[2,3]);
> array_cat
> ---
> {1,2,2,3}
>
> I need to ge
On Wed, 19 Mar 2008, Ondřej Fafejta <[EMAIL PROTECTED]> writes:
> SELECT array_cat(ARRAY[1,2], ARRAY[2,3]);
> array_cat
> ---
> {1,2,2,3}
>
> I need to get result without duplicity!
> {1,2,3}
I don't know any builtin way of achieving such a thing. But you may want
to use intarray contrib m
Hi!
Postgresql: version 8.1.11
Is there a way to concatenate two arrays without duplicity?
This select return duplicity:
SELECT array_cat(ARRAY[1,2], ARRAY[2,3]);
array_cat
---
{1,2,2,3}
I need to get result without duplicity!
{1,2,3}
Thx
Fafi
--
Sent via pgsql-general mailing list
