So I'm using dblink to run a query on another db, which works fine.
I'm wondering if there is some shortcut I can use since I have the type the remote function is returning defined on my side so I don't need to list all the columns - so instead of select * from dblink('select * from someFooTypeReturningFunc()') as t1(col text, ....)
I could write select * from dblink('select ... ') as t1(footype) I've poked over the docs and googled around, haven't seen anything yet. -- Jeff Trout <[EMAIL PROTECTED]> http://www.dellsmartexitin.com/ http://www.stuarthamm.net/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org