Skip site navigation (1) Skip section navigation (2)

Re: information

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Mattia Boccia <ironwallaby(at)yahoo(dot)com>,pgsql-novice(at)postgresql(dot)org
Subject: Re: information
Date: 2002-10-17 16:12:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

>  I'd like to know, if it's possible, which ODBC
>  standard does postsgres support 

That depends on the host Operating System.   Drivers/source are
available for current versions of MS ODBC, unixODBC, and iODBC.

> and where i could
>  find the complete text of ANSI SQL-92 and ANSI
>  SQL-99.
Or, better, buy a copy of C.J. Date's "A guide to the SQL Standard."

>  In the FAQ page i found that the maximum size for a
>  row? is 1.6TB and i'd like to know what exactly
>  they mean with "row".

Um, the definition of "row" in a database is unambiguous.   One row =
One Tuple.   I can't make it any clearer than that.

FYI, most operating systems limit single files to 2GB or less.  As
such, no table -- and thus no row -- in a Postgres database running on
that operating system can be larger than 2GB.   But it's hard for me to
imagine a row that is even 1MB, let alone 2GB, so I don't think you
need to worry.

>  Do u know about any applications realized with
>  Postgres and still working that i could cite to
>  demostrate his reliability?


I believe that their is an Italian version of that page, as well.

-Josh Berkus

In response to

  • information at 2002-10-17 13:48:11 from Mattia Boccia


pgsql-novice by date

Next:From: Josh BerkusDate: 2002-10-17 16:16:50
Subject: Re: char() or varchar() for frequently used column
Previous:From: RobDate: 2002-10-17 15:33:14
Subject: Re: where clauses with and

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group