David Fetter wrote: > On Fri, Aug 18, 2006 at 10:16:12AM -0400, Tom Lane wrote: > > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > > A \set variable would make sense to me. > > > > So Peter and Bruce like a \set variable, Chris and I like a > > different command. Seems like a tie ... more votes out there > > anywhere? > > It seems to me that a \set variable lets people use minimal > intrusiveness on scripts, etc., as they'll just set it when they start > needing cursor-ized result sets and unset it when finished.
True. They could even put it in .psqlrc if they want. Basically need a way to modify \g. Seems a \set is the way we have always done such modifications in the past. The big question is whether this is somehow different. Personally, I don't think so. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match