Thread: Data types

Data types

From

Kevin Waterson

Date:

13 January 2003, 23:38:38

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?

Kind regards
Kevin
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.fsf.org/philosophy/no-word-attachments.html
Kevin Waterson
Port Macquarie, Australia

Re: Data types

From

Andrew McMillan

Date:

13 January 2003, 23:59:12

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/
---------------------------------------------------------------------