[GENERAL] Reloading Template1

e the DB I want, all the view and structures are already there. How to I recreate an empty template1? Thanks -- Hadley Willan » Director » [EMAIL PROTECTED] » +64(21) 28 41 463 Deeper Design Limited » +64(7) 377 3328 » www.deeperdesign.com

Re: [GENERAL] Improving performance with a Function instead of a

shows indexes being used, but the right join for the locale stuff is the killer. Thanks On Thu, 2004-02-05 at 13:31, Mike Mascari wrote: Hadley Willan wrote: > Hi all, > I am using some views now to put together a particular format for > my Java client factory to produce Java Beans fro

Re: [GENERAL] Date manipulation

Yes, I'm not worried about an exact DST.  The date items are stored with Timestamp Timezone. Thanks to everybody for your technical tips and help. Hadley On Mon, 2004-04-19 at 16:42, Tom Lane wrote: Bruno Wolff III <[EMAIL PROTECTED]> writes: > Hadley Willan <[EMAIL

[GENERAL] Dynamic SQL

Hi all,     I'd like to write a function that would allow me to verify some attributes on a table so that I could give a meaningful error message... I've been playing with passing in to a plpgsql function the following things. CREATE OR REPLACE FUNCTION fn_verifyObject( VARCHAR, VARCHAR, BIGI

[GENERAL] Is it possible to get the 7.4.1 static docs in HTML form anymore?

Reason being I'd like to install them locally on my laptop so that when I'm lap topping it, I still have docs without the need for an Internet connection. Regards.     Hadley