Re: DOes PostgreSQL support UInt64?

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