On Thu, Dec 22, 2005 at 06:35:24PM -0500, Bruce Momjian wrote: > Hannu Krosing wrote: > > ?hel kenal p?eval, N, 2005-12-22 kell 18:19, kirjutas Bruce Momjian: > > I guess he rather wants to have dont-save-but-execute-immediately > > pl/pgsql code. > > > > could this perhaps be solved by having temporary functions, similar to > > postgresql's temporary tables ? > > I am thinking they want the ability to sit at a prompt and type stuff.
FWIW, I would find the ability to run stuff from the prompt useful for debugging plpgsql functions. Rather than edit function def CREATE OR REPLACE FUNCTION ... test function you could just edit in-place and test. Of course having the ability to execute arbitrary plpgsql in .sql scripts would be handy in some cases as well, though as others pointed out there are alternatives. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq