On Tuesday 16 December 2003 10:12, C G wrote: > Thanks for your help but I still have a small problem. I'm try to do as you > suggested and use prepare/execute but I'm doing something silly. > > I'm using: > > PREPARE my_prep1(name) AS SET SESSION AUTHORIZATION $1; > > and get the error message: > ERROR: syntax error at or near "set" at character 27
You want EXECUTE. Something like: DECLARE set_qty text; ... set_qry := ''SET SESSION AUTHORIZATION '' || $1; EXECUTE set_qry; -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
