ср, 22 апр. 2020 г. в 21:04, Mark Rotteveel <m...@lawinegevaar.nl>: > > On 2020-04-22 19:02, Jiří Činčura wrote: > >> Why to remove the Array type ? , I see that Postgresql still provides > >> it https://www.postgresql.org/docs/current/arrays.html > > > > Arrays in PG have better performance and the support in PL/pgSQL is > > good too. > > That doesn't mean we should just remove them, we could also improve > support for arrays in Firebird, both in PSQL, DSQL and in the > API/protocol
I agree. > With regard to performance, the problem with arrays in Firebird is that > - just like blobs - they are out-of-band: you need separate requests to > get them. > > That said, I've never had the need to use arrays, and I won't miss them > if they are gone. They probably havn't been used because of weak support at SQL/PSQL level. Recently I've analyzed requirements of the Federal Tax Service of Russia to Database Server. They declared that DBMS like RedDatabase (Firebird), PostgresPro (Postgres), etc. can't handle their needs. I could agree with them about performance and maybe scalability. But regarding functional features Firebird almost fits the requirements. Supporting of ARRAYs also required. Maybe it's must be implemented in another way but before we understand it we should not neither remove it nor depricate it. At least if there are no strong reasons that block other good aims. -- Roman Simakov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
