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 <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
