Re: Max length for a select or other command

Patrick Robin wrote:
>
> Is there a limit to the length in characters for a select command in
> Postgres?
>
> Thanks

No. There isn't a limit with regarding the selecting of data out
of PostgreSQL. But there currently is a record limit of around 8K
(generally speaking) in 7.0.x. So you could have a query, for
example, which appends 100K of string constants as apart of a
select. Anyway, that limit is scheduled to be removed in 7.1,
allowing you to store objects of an arbitrary size in the
database. This includes the excellent implementation of NUMERIC,
which performs arithmetic of arbitrary precision. Have a look at:

http://www.postgresql.org/projects/devel-toast.html

for details. I believe there might also exist some limitations
remaining in some of the interfaces, but I'm not quote sure. I
know that libpq, the C interface library, has had all query
length limits removed.

Hope that helps,

Mike Mascari