public void NumericPrecision()
{
using (var conn = OpenConnection())
{
conn.ExecuteNonQuery("CREATE TEMP TABLE data (a NUMERIC(8), b NUMERIC, c INTEGER)");
using (var cmd = new NpgsqlCommand("SELECT a,b,c,8.3::NUMERIC(8) FROM data", conn))
using (var reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))
{
var columns = reader.GetColumnSchema();
Assert.That(columns[0].NumericPrecision, Is.EqualTo(8));
Assert.That(columns[1].NumericPrecision, Is.Null);
Assert.That(columns[2].NumericPrecision, Is.Null);
Assert.That(columns[3].NumericPrecision, Is.EqualTo(8));
}
}
}