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 alo

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