Re: Tableau dans une requête

Samuel ROZE wrote:

> EXECUTE 'SELECT id_couple_critere , count(*)
> FROM graphiques.critere
> WHERE lib_critere = ANY ''$1''
> GROUP BY id_couple_critere
> HAVING count(*) = $2' INTO v_id_couple USING v_criteres_str,
> array_upper(v_criteres, 1);

Pourquoi utiliser EXECUTE ou autrement dit en quoi la version ci-dessous ne
conviendrait pas?

SELECT id_couple_critere , count(*)
FROM graphiques.critere
WHERE lib_critere = ANY (v_criteres)
GROUP BY id_couple_critere
HAVING count(*) = array_upper(v_criteres, 1);

--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org