On Wed, Dec 27, 2006 at 06:36:56PM -0500, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > On Wed, Dec 27, 2006 at 06:22:17PM -0500, Tom Lane wrote: > >> The problem with that is that "AS foo" already has a meaning, and it's > >> not this one. > > > How about "AS (foo)" ? > > What if you want to specify an alias? This doesn't work: > > FROM myverylongfunctionname(...) AS alias(typename) > > because, again, that syntax already has a meaning.
Oops. > You could possibly do something with a cast: > > FROM CAST(myfunc(...) AS typename) [ AS alias ] Works for me. > This is at least syntactically OK. Not sure what the implementation > issues might be. I'm not finding any CASTs from RECORD right offhand. Where might those be? Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
