Re: [GENERAL] Difficulty passing in an array of values to EXECUTE

William Leite Araújo wrote: > > 2006/10/25, Richard Huxton mailto:dev@archonet.com>>: > > Nick Rowlands wrote: > > Hi there, > > > > I'm having trouble creating a function using plpgsql. I cannot > pass the > > array &

[GENERAL] Difficulty passing in an array of values to EXECUTE SELECT statement

Hi there, I'm having trouble creating a function using plpgsql. I cannot pass the array 'productids' to the ANY construct of the IN EXECUTE SELECT statement. Any ideas on what I'm doing wrong would be most appreciated. Here's the function: CREATE OR REPLACE FUNCTION search_products(metalparam int