Re: [GENERAL] eval in plpgsl

2004-04-08 Thread Jan Wieck
Bruce Momjian wrote: Mage wrote: Hello, is there any variable variable syntax or function in plpgsql? I didn't find it. I mean something like: magic(''new.'' || TG_ARGV[0]) = 5; Uh, we have EXECUTE, but I don't know if will allow you to set a local variable. Maybe you can do: EXECUT

Re: [GENERAL] eval in plpgsl

2004-04-08 Thread Jeff Eckermann
--- 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

Re: [GENERAL] eval in plpgsl

2004-04-08 Thread Mage
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 Mage ---(end of broadcast)--- TIP 7: don't forget to increase your free space ma

Re: [GENERAL] eval in plpgsl

2004-04-07 Thread Bruce Momjian
Mage wrote: > Hello, > > is there any variable variable syntax or function in plpgsql? I didn't > find it. > > I mean something like: magic(''new.'' || TG_ARGV[0]) = 5; Uh, we have EXECUTE, but I don't know if will allow you to set a local variable. Maybe you can do: EXECUTE