Re: semi-variable length type - Mailing list pgsql-general

>
> James Harper <james.harper@bendigoit.com.au> 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