Re: make == as = ?

scott.marlowe wrote:
> On Thu, 8 Apr 2004, Bruce Momjian wrote:
> 
> > Fabien COELHO wrote:
> > > 
> > > > > This would help me, at least, write correct and portable SQL. :)
> > > >
> > > > Added to TODO:
> > > >
> > > >     * Add a session mode to warn about non-standard SQL usage
> > > 
> > > So it seems that having C-like operators would hurt a lot;-)
> > > 
> > > So you want to generate warnings for SERIAL, TEXT and a bunch of other
> > > types, WITH[OUT] OIDS, RULE, ~ regular expressions, arrays, any use of
> > > pg_catalog instead of information_schema (I may be wrong in the list, I
> > > don't have the standard at hand, but I think I'm right in the spirit)...
> > > 
> > > This is going to be noisy;-)
> > 
> > Yep, it sure is going to be noisy.
> 
> Could we consider a three (or more) way setting, for what to do?  
> Something like:
> 
> sql_noncompliance_mode = error;
> sql_noncompliance_mode = warn / notice;
> sql_noncompliance_mode = ignore;

I think a boolean that turns on warnings would be enough.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073