Re: [GENERAL] On duplicate ignore

> Just create a unique index on EMAIL column and handle error if it comes Thanks for your suggestion. Of course, I do understand that this could be enforced/imposed at the database-level at any time. But I'm trying to find out whether this could be solved at the application layer itself. Any th

[GENERAL] On duplicate ignore

Hi, Ours is a web-based application. We're trying to implement ON DUPLICATE IGNORE for one of our application table, named EMAILLIST. After a quick Google search, I'm finding the following "easy & convenient" single SQL statement syntax to follow with: INSERT INTO EMAILLIST (EMAIL) SELEC

Re: [GENERAL] Is TRUNCATE a DML statement?

>> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscriptio

[GENERAL] Is TRUNCATE a DML statement?

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 -- Sent via pgsql-general mailing list (pgsql-general@postgres

[GENERAL] How to ALTER VARCHAR datatype to TEXT ?

Hi, I'm using PostgreSQL version 7.1.3. I would like to change the data type of a column from VARCHAR to TEXT. Is this possible? If possible, how should I do it? Can anyone throw some light on this. - Gnanam Yahoo! Ind