Re: the integer type - Mailing list pgsql-general

From chris smith
Subject Re: the integer type
Date
Msg-id 3c1395330604130717s15849e8do83fb07d4a023bbe8@mail.gmail.com
Whole thread Raw
In response to the integer type  ("Zahir Lalani" <zahir@systemz.net>)
List pgsql-general
> I have only recently started to use Postgresql and have a problem. I am
> using v8.1 on windows.
> I cannot seem to get the DB to accept either INT or INTEGER as a type
> when using the admin tool. Only INT2 or INT4 work.
> I even downloaded Navicat trial and this has the same issue. Is there a
> setup required to allow these
> standard types to be enabled?

It's a built in type so you don't need to do anything.

So something like this:

create table t1(a int);

fails?

What message do you get?

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: "Harald Armin Massa"
Date:
Subject: Re: browser shows garbage instead of UTF-8 characters
Next
From: Gaetano Mendola
Date:
Subject: Re: [HACKERS] RH9 postgresql 8.0.7 rpm