Re: DOes PostgreSQL support UInt64? - Mailing list pgsql-general

From Meenatchi Anbuchelvan
Subject Re: DOes PostgreSQL support UInt64?
Date
Msg-id 20011031150204.25408.qmail@web10507.mail.yahoo.com
Whole thread Raw
In response to Re: DOes PostgreSQL support UInt64?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks to you both. The version that I am using is
PostgreSQL 7.0.3-8, the one thats gets shipped on
RedHat7.1 CD.
I have one more question related to data types. The
document says Postgres suports "text", but it is not
SQL compliant. Does this mean, there is no
corresponding type in SQL? So in my ODBC code I
wouldnt
be able to use a type corresponding to "text". Please
let me know..

Thanks,
Meenatchi

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Meenatchi Anbuchelvan <maatchi@yahoo.com> writes:
> > Does anyone know if Postgres supports UInt64.
>
> It does not.
>
> > create table table1(name varchar(20), num bigint),
> i
> > get an error message which says
> > "ERROR:  Unable to locate type name 'bigint' in
> > catalog".
>
> How old is your Postgres?  That works fine in recent
> releases.
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org


__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com

pgsql-general by date:

Previous
From: Antonio Sergio de Mello e Souza
Date:
Subject: Re: function gurus...
Next
From: wsheldah@lexmark.com
Date:
Subject: alter table workaround