To: Peter Eisentraut <peter_e@gmx.net>
cc: Andrew Dunstan <andrew@dunslane.net>, Robert Haas <robertmhaas@gmail.com>,
	Sam Mason <sam@samason.me.uk>, pgsql-hackers@postgresql.org
Subject: Re: GRANT ON ALL IN schema 
In-reply-to: <1250427428.26280.2.camel@vanquo.pezone.net> 
References: <603c8f070908050951s3e5df452se4c610f01b80bb7d@mail.gmail.com>
	<4A7FE7F902000025000296E3@gw.wicourts.gov>
	<4A803A89.9020509@dunslane.net>
	<2CCE9C1D-919D-45D5-BFC2-C7723C45064E@hi-media.com>
	<162867790908150434j7aef36ecm202e81c4bb4740fa@mail.gmail.com>
	<4A86B5D5.6060807@dunslane.net> <4A871F46.1040002@agliodbs.com>
	<5D5ECAE0-F2B0-479B-9594-50AAF18F10ED@hi-media.com>
	<20090815223102.GS5407@samason.me.uk>
	<1250378139.18992.6.camel@vanquo.pezone.net>
	<603c8f070908152051mbd1d706hb0e29f5cfaf2f151@mail.gmail.com>
	<4A87854B.3070707@dunslane.net>
	<1250427428.26280.2.camel@vanquo.pezone.net>
Comments: In-reply-to Peter Eisentraut <peter_e@gmx.net>
	message dated "Sun, 16 Aug 2009 15:57:08 +0300"
Date: Sun, 16 Aug 2009 12:12:40 -0400
Message-ID: <395.1250439160@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Peter Eisentraut <peter_e@gmx.net> writes:
> On sön, 2009-08-16 at 00:04 -0400, Andrew Dunstan wrote:
>> SQL is not Lisp. Simple is  good. I didn't think Peter was really very 
>> serious.

> Well, I don't know if we really need to call it "lambda", but I fully
> expect to be able to use these "ad hoc functions" as part of other
> expressions.

Why would you expect that?  To be used in an expression, you'd also need
decoration to tell the function argument types, result type, volatility
properties, etc etc (your proposed lambda notation is far too
simplistic).  I think you're moving the goalposts to a point where we'd
need ANOTHER, simpler, mechanism to accomplish the original intent.
And frankly, all of the user demand I've heard is for the latter not
the former.  By the time you get into specifying function properties
you might as well just create a function.

			regards, tom lane