Re: [SQL] Passing arrays - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: [SQL] Passing arrays
Date
Msg-id 20030213205623.V56568-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Passing arrays  (Michael Weaver <mweaver@corpusglobe.com>)
List pgsql-novice
On Fri, 14 Feb 2003, Michael Weaver wrote:

> How do you get an array of elements to be passed to a stored proc such that
> you can use the array in a SELECT statement in the WHERE clause
>  - e.g.  WHERE field IN (array) etc...

A straight WHERE field IN (array) doesn't work.  That's attempting to
compare the field directly to the array as a whole (which is why you get
the particular error you do.

You might want to look at contrib/array for some loadable
functions/operators in working with arrays.


pgsql-novice by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: [SQL] Passing arrays
Next
From: brew@theMode.com
Date:
Subject: Re: change year in timestamp