On Thu, Nov 14, 2002 at 17:00:30 +0000, snpe <[EMAIL PROTECTED]> wrote: > On Thursday 14 November 2002 05:01 pm, Bruno Wolff III wrote: > > On Thu, Nov 14, 2002 at 16:49:42 +0000, > > > > snpe <[EMAIL PROTECTED]> wrote: > > > I want that 'create or replace view' work drop-create if view exists else > > > only create > > > > Why do you want this? > > > > Why 'create or replace' ?
Why do you want create or replace to do a drop, then a create if the view exists but it is being changed in a way that will break any objects that refer to the old view? Are you trying to save typing a few characters or what? ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org