El Mié 24 Ene 2001 08:06, Zak McGregor escribió: > > Other irritations I've found with MySQL are (briefly): > - no subselects (makes for ugly hacks in code) > - no views > - no foreign keys Didn't know they didn't have foreign keys. :-( > - no constraint support > - completely lacking date integrity checking (eg will accept '2001-15-45' > as a valid date). That is pretty ugly. - no rules > - no triggers > - no intersects or unions > - table-level locking only > - inability to go beyond FS limits of filesize for databases > All in all, about the only thing MySQL has going for it is the replication. > > The only issues I've had with PostGres are: > - this doesn't work: select a from b where a.fld in (select c from d where > e = f intersect select c from d where e=g) but I believe that will be > working in 7.1 > - 8k row limit > pretty severe, but can be fixed at copmpile-time to 32k. Completely > removed for 7.1 Both (AFAIK) are added in 7.1 -- System Administration: It's a dirty job, but someone told I had to do it. ----------------------------------------------------------------- Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------
