Postgres Pro
Downloads
Home   >   mailing lists

Thread: Is TRUNCATE a DML statement?

Is TRUNCATE a DML statement?

From
"Gnanakumar"
Date:
Hi,

Can we say that TRUNCATE belongs/falls under DML statement?

TRUNCATE: http://www.postgresql.org/docs/8.2/interactive/sql-truncate.html

I also understand that "There is no TRUNCATE command in the SQL standard."

Regards,
Gnanam

Re: Is TRUNCATE a DML statement?

From
Pavel Stehule
Date:
Hello

2010/8/26 Gnanakumar <gnanam@zoniac.com>:
> Hi,
>
> Can we say that TRUNCATE belongs/falls under DML statement?
>
> TRUNCATE: http://www.postgresql.org/docs/8.2/interactive/sql-truncate.html
>
> I also understand that "There is no TRUNCATE command in the SQL standard."
>

this is old information - now TRUNCATE is part of SQL standard ANSI
SQL 2008 - F200

Regards

Pavel Stehule



> Regards,
> Gnanam
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: Is TRUNCATE a DML statement?

From
"Gnanakumar"
Date:
>> I also understand that "There is no TRUNCATE command in the SQL standard."

> this is old information - now TRUNCATE is part of SQL standard ANSI
> SQL 2008 - F200

Thanks for the update.