Re: 8.2 features status

On Fri, Aug 04, 2006 at 01:41:42PM -0700, Joshua D. Drake wrote:
> >>>issue DDL
> >>You mean something like: EXEC plperl(print $foo)?
> >
> >Something like this:
> >
> >SELECT a, b, c
> >FROM (
> > EXECUTE IMMEDIATE
> > LANGUAGE plperl
> > $$...$$
> >) AS (a int, b point, c text)
> >JOIN ...
> >
> >Anyhow, the idea is to be able to call PL functionality in-line
> >without having to create a function in advance.
>
> Well that is certainly interesting. Opens up a whole lot of flexibility,
> especially to views and such.
>
> Seems a little unnatural though ;)

That's the table constructor version. It would be nice to call other
versions, too, like

SELECT
CALL IMMEDIATE
LANGUAGE plpython $$...$$ (a, LOWER(b))
AS wacky_python_output
FROM ...

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!