--- Mage <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
