Re: queries problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Joÿffffffffffe3o Carvalho <joaocarvalho127(at)yahoo(dot)com(dot)br>, pgsql-sql(at)postgresql(dot)org
Subject: Re: queries problems
Date: 2005-09-09 00:16:53
Message-ID: 27001.1126225013@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Michael Fuhr <mike(at)fuhr(dot)org> writes:
> I don't know if there's an easier way to check if an int2 is a
> member of an int2vector, but you could write a function to convert
> an int2vector to an int2 array and then use an "= ANY" expression.

FWIW, as of 8.1 an int2vector *is* an int2 array, so = ANY just works.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message miwalsh 2005-09-09 00:43:37 Numeric Columns
Previous Message Michael Fuhr 2005-09-08 23:54:35 Re: queries problems