Changes
Jump to navigation
Jump to search
no edit summary
A corresponding Drop table scripts is also available at
/bulk/Software/Database\ Scripts/droptables.sql
==Converting DataTypes==
Method 1: Explicit recast
CAST function
Method 2: implicit recast
SELECT varname::type
Method 3: through a language
CREATE OR REPLACE FUNCTION chartoint (text) RETURNS int AS $$
if ($_[0]) {
return $_[0];
}
return undef;
$$ LANGUAGE plperl;
==Creating the tables==
