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 'productids' to the ANY construct of the IN EXECUTE SELECT

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

2006/10/25, Richard Huxton : Nick Rowlands wrote:> 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'

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

Nick Rowlands wrote: 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: FOR row IN EXECUTE 'SELECT p

[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