> > > OO in PostgreSQL means that you can create own operators, datetypes,
> > functions...
> > Last I checked, all of these things were part of the SQL spec. I believe our
> > only "OO" functionality is inheritance ... which I have yet to find a use
> > for.
> Can you tell me what the SQL99 spec says regarding creation of
> operators? I couldn't find them.
I haven't gone back and looked, but I recall that the spec makes some
mention of operators in the context of defining new functions. I don't
think there is anything about defining operators not already in SQL, but
only (if anything at all) about extending existing operators to new data
types.
- Thomas