> Bruce Momjian wrote:
> > >
> > > > ENHANCEMENTS
> > > > ------------
> > > > * Add full ANSI SQL capabilities
> > > > * add OUTER joins, left and right (Thomas)
> > > > * add INTERSECTS, SUBTRACTS(Stephan)
> > > > * add temporary tables
> > > > * add sql3 recursive unions
> > > > * add the concept of dataspaces
> > > > * add DECIMAL, NUMERIC, DOUBLE PRECISION, BIT, BIT VARYING
> > >
> > > We've got DOUBLE PRECISION, DECIMAL, and NUMERIC (the latter two are
> > > brain-damaged though)
> >
> > Removed.
>
> If it's brain-damaged should'nt it be justr Replaced instead of Removed
We just need to add better precision to the type.
>
> >
> > >
> > > > * add CONSTRAINT
> > >
> > > Already here, from Vadim.
> > Removed.
> >
>
> AFAIK, CONSTRAINTS ar currently available only at table create time ?
>
> So once you have (or have.nt) them, you must stay with it ;(
>
> creating/dropping constraints should be made to work in ALTER TABLE as
> well
Already on list:
* ALTER TABLE ADD COLUMN does not honor DEFAULT, add CONSTRAINT
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026