Thread: query length limits

query length limits

From
"tjk@tksoft.com"
Date:
Does Postgres have any limitations on
the length of queries?

E.g. is "select one,two,three,...thousand from one,two,three,...thousand where one = x and two is x and three is x and
...thousand = x" legal? 

I could test this of course, but I am curious about the real
limits imposed by the system, and any possible consequences,
plus any changes planned in the future which might affect
this issue.


Thanks,


Troy

Troy Korjuslommi                Tksoft OY, Inc.
tjk@tksoft.com                  Software Development
                                Open Source Solutions
                                Hosting Services