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
_______________________________________________
grass-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-dev
