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