> > > hannu-> check (trim(a) <> '' or trim(b) <> ''));
> > > ERROR: parser: parse error at or near "trim"
> >
> > TRIM is keyword, not a function...
> > We have to copy some lines in gram.y
I think that having trim as a keyword is a problem. The primary virtue of
postgres is that everything is either a function or a type and as such is
definable by the user and resolved at runtime. Making a keyword out of a
function spoils that capability.
-dg
David Gould dg@illustra.com 510.628.3783 or 510.305.9468
Informix Software (No, really) 300 Lakeside Drive Oakland, CA 94612
- If simplicity worked, the world would be overrun with insects. -