Re: Data types

On Tue, 2003-01-14 at 14:46, Kevin Waterson wrote:
> I have been reading up on table creation with postgres but
> cannot see anything on data types. I have been looking at
> http://www.postgresql.org/idocs/index.php?tutorial-table.html
>
> and if gives an example..
>
> CREATE TABLE weather (
>     city            varchar(80),
>     temp_lo         int,           -- low temperature
>     temp_hi         int,           -- high temperature
>     prcp            real,          -- precipitation
>     date            date
> );
>
> what is real?
> Is there a list of data types?

Yep.  The manual has one in chapter 3...

http://www.postgresql.org/idocs/index.php?datatype.html

Cheers,
                    Andrew.
--
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/
---------------------------------------------------------------------