On Tue, Oct 30, 2007 at 11:31:12AM -0300, Alvaro Herrera wrote: > David Fetter wrote: > > > AS $$ > > BEGIN > > OPEN $1 FOR SELECT * FROM foo; > > RETURN NEXT $1; > > OPEN $2 FOR SELECT * FROM bar; > > RETURN NEXT $2; > > END; > > $$; > > I know it. It is ugly as all hell.
Agreed. Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match