From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Fuhr <mike@fuhr.org>
Cc: Joÿffffffffffe3o Carvalho <joaocarvalho127@yahoo.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: queries problems
Date: Thu, 08 Sep 2005 20:16:53 -0400
Message-ID: <27001.1126225013@sss.pgh.pa.us> (raw)
In-Reply-To: <20050908235435.GA68913@winnie.fuhr.org>
References: <20050902020346.GA58397@winnie.fuhr.org>
<20050908223348.21917.qmail@web50614.mail.yahoo.com>
<20050908235435.GA68913@winnie.fuhr.org>
Michael Fuhr <mike@fuhr.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, mike@fuhr.org, joaocarvalho127@yahoo.com.br
Subject: Re: queries problems
In-Reply-To: <27001.1126225013@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox