Re: need query advice

argh, you could use contribs/intarray with a gist index...
instead of N columns use an integer[] and gist-index it, then write the
equivalent of :

where (intersection of the search array with the data array) has at least
5 elements
(or 4 elements)

(or at least 4 elements order by the number of elements desc)

in your table defs, you can express your unicity constraint on the array
with :
CHECK( uniq(yourarrau) = yourarrau AND length(yourarrau)=6 )



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
lists [ Mi, 20 Oktober 2004 02:14 ] [ ID #453846 ]
Datenbanken » comp.databases.postgresql.sql » Re: need query advice

Vorheriges Thema: Re: help with to_date and to_char
Nächstes Thema: Re: the problem of createlang!