To: Josh Berkus <josh@agliodbs.com>
cc: Robert Haas <robertmhaas@gmail.com>, Petr Jelinek <pjmodos@pjmodos.net>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: GRANT ON ALL IN schema 
In-reply-to: <4A79ECDF.4020700@agliodbs.com> 
References: <4A37BF63.50008@pjmodos.net> <4A37E122.8070303@pjmodos.net>
	<4A38A956.8080600@pjmodos.net> <4A4DE104.8090605@pjmodos.net>
	<a301bfd90907170254re7dd52es9fedb007376d8055@mail.gmail.com>
	<4A6059B4.5010004@pjmodos.net> <4A607997.3030305@pjmodos.net>
	<21542.1249492707@sss.pgh.pa.us> <4A79D60D.1090900@agliodbs.com>
	<603c8f070908051221u676e9d68ya42f5099aafb2e8e@mail.gmail.com>
	<28123.1249501226@sss.pgh.pa.us> <4A79ECDF.4020700@agliodbs.com>
Comments: In-reply-to Josh Berkus <josh@agliodbs.com>
	message dated "Wed, 05 Aug 2009 13:34:39 -0700"
Date: Wed, 05 Aug 2009 16:55:06 -0400
Message-ID: <29601.1249505706@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Josh Berkus <josh@agliodbs.com> writes:
>> Josh's position that "this should be standard SQL" is nonsense, or
>> at least he ought to be making that argument to the standards committee
>> not us.  

> Huh?  When did I say that?

Sorry, I think I got one of your messages confused with one of Robert's.
Anyway,

> *Built-in* functions are just as good as extra syntax, as far as I'm
> concerned.

> Functions which require installing plpgsql, reading the docs, creating a
> function, pasting it in, and saving it are NOT as good; they are
> unlikely to ever be used, except by the people who didn't really need
> them in the first place.

Agreed, whatever we want to provide here should be available in a
vanilla installation.  This might argue for providing a C-code
implementation instead of plpgsql, since I'm not sure we are yet
ready to have plpgsql force-installed.  But we can certainly design
and prototype in plpgsql.

			regards, tom lane