[GRASS-dev] Misleading help of v.db.add*

[Moritz Lennert]

On 27/06/08 23:38, Huidae Cho wrote:
> Moritz,
> 
> I did some research about SQL2003-compliant data types and found the
> SQL2003 specification (http://savage.net.au/SQL/sql-2003-2.bnf.html).
> According to the specification, VARCHAR, INT, DOUBLE PRECISION, and DATE
> are standard data types, and "MySQL treats DOUBLE as a synonym for
> DOUBLE PRECISION (a non-standard extension)"
> (http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html).  Since the
> built-in SQL parser supports "DOUBLE PRECISION", the dbf backend has no
> problem with this data type.  SQLite is also fine because it's typeless.
> However, PostgreSQL does not recognize "DOUBLE", so I suggest to adapt
> the help message.
> 
> What do you think?

Thanks for your research !

Please go ahead to change if you want to, otherwise I'll do it. I also 
think the rest of the text needs some improvement to make it clear what 
exactly is expected.

Moritz