[SQL] using a selected row as a function parameter

2005-06-03 Thread Ami Ganguli
Hi all, I've been struggling with this for a while and haven't found anything on the 'Net about it. I've created a function that takes two table rows as a parameters. I'd like to use the output of a select (two single rows) as the parameters, but I can't get it to work. What am I missing? The

Re: [SQL] using a selected row as a function parameter

2005-06-03 Thread Tom Lane
Ami Ganguli [EMAIL PROTECTED] writes: SELECT queue.apply_routing_rule( (SELECT * from queue.messages WHERE id = 1), (SELECT * from queue.routing_rules WHERE id = 1) ); Not sure if that particular syntax should be expected to

Re: [SQL] using a selected row as a function parameter

2005-06-03 Thread Michael Fuhr
On Fri, Jun 03, 2005 at 05:44:59PM +0300, Ami Ganguli wrote: SELECT queue.apply_routing_rule( (SELECT * from queue.messages WHERE id = 1), (SELECT * from queue.routing_rules WHERE id = 1) ); I get an error message along the