On Fri, Jul 25, 2008 at 07:13:34AM -0500, Kirk Abbott wrote:
Hello,
I understand where 'Delete all' or 'delete * from table' works just as well as a truncate... But how about the issue of code maintenance and porting from other DBs? Could there be some value is supporting features from other 'sql dialects'?
You could add a feature request, see the source forge site. Shouldn't be to hard to rewrite a truncate table x into delete from table. Niels
Kirk
Niels Nes wrote:
On Fri, Jul 25, 2008 at 08:24:58PM +0900, nori wrote:
Hi, All.
Is there the function such as "TRUNCATE TABLE" in other DB?
There is no need for a special 'TRUNCATE TABLE'. A delete all is handled efficiently by the log allready.
So you can use delete all.
Niels
Regards, Nori.
-- Nori [1]tunohiko@gmail.com
References
1. mailto:tunohiko@gmail.com
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl