Re: [GENERAL] IF EXISTS

2006-09-24 Thread stevethames
? Then it would be possible to create scripts for database maintainance that could be run periodically without having to make them functions stored in the database. Just a thought. Cheers! Jeff Davis-8 wrote: > > On Wed, 2006-09-20 at 14:18 -0700, stevethames wrote: >> I have a

[GENERAL] IF EXISTS

2006-09-20 Thread stevethames
I have a script that sets up my databases which I run whenever I change any of the functions. It has a number of things it does that are unnecessary and cause errors. I create some types, sequences, etc. The error messages are irritating. I'd like to do something like this: IF NOT EXISTS (SEL