> > James Harper <james.harper@xxxxxxxxxxxxxxxx> writes: > > I want to make a float(n) type that emulates the mssql float type. The > > storage requirements are documented as 4 bytes for 1 <= n <=24, and 8 > > bytes for 25 <= n <= 53. > > Haven't we got that already? > > regression=# create table t1 (f1 float(5), f2 float(30)); > CREATE TABLE > regression=# \d t1 > Table "public.t1" > Column | Type | Modifiers > --------+------------------+----------- > f1 | real | > f2 | double precision | > > Other than the fact that we don't remember whether you asked for 5 bits > or 24, I think this meets the spec requirements. > Is the 4 byte or 8 byte decision based on (n) implemented in the parser? I can't see a 'float' type in pg_type. Thanks James -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
