Re: eval in plpgsl

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Mage <mage(at)mage(dot)hu>, pgsql-general(at)postgresql(dot)org
Subject: Re: eval in plpgsl
Date: 2004-04-08 14:03:18
Message-ID: 20040408140318.38548.qmail@web20805.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Mage <mage(at)mage(dot)hu> wrote:
> Bruce Momjian wrote:
>
> >
> >Uh, we have EXECUTE, but I don't know if will allow
> you to set a local
> >variable. Maybe you can do:
> >
> >
> execute doesn't support select into

It does, if you use the "for variablename in execute
..." syntax. Which may seem like overkill for setting
just one value, but at least it will work for you.

Or you could investigate other procedural languages,
which may offer the capability you want. I believe
pltcl does, and perhaps plpython also.

>
> Mage
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map
settings

__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sky 2004-04-08 14:21:33 Oid problem
Previous Message Tom Lane 2004-04-08 14:01:35 Re: Problem with pg_dump - reg.