array_cat without duplicity - Mailing list pgsql-general

From Ondřej Fafejta
Subject array_cat without duplicity
Date
Msg-id 47E11D92.8070000@kyberie.cz
Whole thread Raw
Responses Re: array_cat without duplicity  (Volkan YAZICI <yazicivo@ttmail.com>)
Re: array_cat without duplicity  (David Fetter <david@fetter.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Leon Mergen"
Date:
Subject: Re: Conditional JOINs ?
Next
From: Volkan YAZICI
Date:
Subject: Re: array_cat without duplicity