On Wed, Dec 27, 2006 at 06:11:55PM -0600, Andrew Dunstan wrote: > 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. > > > > You could possibly do something with a cast: > > > > FROM CAST(myfunc(...) AS typename) [ AS alias ] > > > > This is at least syntactically OK. Not sure what the implementation > > issues might be. > > > > > For some time now I have wanted to genaralise the use of LIKE in type > expressions, which might perhaps fit David's need. Something like > > SELECT * from foo() AS bar (LIKE blurfl); > > The nice thing about this is that you could augment the type expression: > > SELECT * from foo() AS bar (extra_info text, LIKE blurfl);
That would be really handy. As with CREATE TABLE, you could pile together several LIKEs and get whatever you needed :) 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 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
