pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Sam Mason <sam@samason.me.uk>
To: pgsql-hackers@postgresql.org
Subject: Re: GRANT ON ALL IN schema
Date: Sun, 16 Aug 2009 02:48:19 +0100
Message-ID: <20090816014819.GT5407@samason.me.uk> (raw)
In-Reply-To: <1250378139.18992.6.camel@vanquo.pezone.net>
References: <200908101042.35024.peter_e@gmx.net>
	<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>

On Sun, Aug 16, 2009 at 02:15:39AM +0300, Peter Eisentraut wrote:
> On 2009-08-15 at 23:31 +0100, Sam Mason wrote:
> > Next all you need is to be able to PREPARE them (and somehow access the
> > parameters from execute) and you'll have nice local functions. :)
> 
> Yeah, rather than just making up some new command for "execute this
> string", this could be generalized as lambda expressions that could be
> called whereever an expression is allowed.  E.g.
> 
> SELECT LAMBDA $$ ... $$;
[..]
> SELECT (LAMBDA (x int, y text) $$ ... $$) (37, 'foo');

I can't quite tell if you're being serious or not, you realize that this
leaves open the possibility of doing:

  SELECT t.n, f.op, f.fn(t.n)
  FROM generate_series(1,10) t(n), (VALUES 
    ('id',LAMBDA (_x int) $$ BEGIN; RETURN _x;   END; $$),
    ('*2',LAMBDA (_x int) $$ BEGIN; RETURN _x*2; END; $$)) f(op,fn)

And of storing lambda abstractions in tables?

-- 
  Sam  http://samason.me.uk/



view thread (83+ messages)  latest in thread

Message-ID: <20090816014819.GT5407@samason.me.uk>
Permalink:  ../20090816014819.GT5407@samason.me.uk/
Also on:    postgresql.org/message-id/20090816014819.GT5407@samason.me.uk

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: sam@samason.me.uk
  Subject: Re: GRANT ON ALL IN schema
  In-Reply-To: <20090816014819.GT5407@samason.me.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox