DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=N3of5R0ofJh46i8DIpRORliseWA9E3X+sRReo1Bl45dlW9mXrYckMGhsDFlgECIQ26
	Haf9bCZX7UBx1FQlEPjoSd7A1agZ5gAbmHX0JNlo1ItITzZOf/e1Q4cAJrlKQyVXPEWr
	GVb2FAjwFBNlZVisqdlRTXUadab5OINfHvRI4=
MIME-Version: 1.0
In-Reply-To: <f16f7ea00908260619t59555d37u66bebfe47132304f@mail.gmail.com>
References: <f16f7ea00908260619t59555d37u66bebfe47132304f@mail.gmail.com>
Date: Wed, 26 Aug 2009 15:32:02 +0200
Message-ID: <162867790908260632o685077a7xc125871fd1f6149@mail.gmail.com>
Subject: Re: Selecting values from comma separated string
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Nacef LABIDI <nacef.l@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hello

postgres=# select * from foo;
+---+---+
| i | a |
+---+---+
| 1 | a |
| 2 | b |
| 3 | c |
+---+---+
(3 rows)

Time: 0,654 ms
postgres=# select * from foo where i = ANY (string_to_array('1,3',',')::int[]);
+---+---+
| i | a |
+---+---+
| 1 | a |
| 3 | c |
+---+---+
(2 rows)

Time: 0,914 ms

regards
Pavel Stehule


2009/8/26 Nacef LABIDI <nacef.l@gmail.com>:
> Hi all,
>
> I want to write a function that takes as param a comma separated values
> string and perform a select matching these values.
>
> Here is the string '1,3,7,8'
>
> And I wan to perform a : SELECT * FROM my_table WHERE id IN (1, 3, 7, 8);
>
> Does anyone have a clue ?
>
> Thanks
>
> Nacef
>