Re: Re[2]: Search (select) options // Max SQL length?

Barry Hill <barry@penrallt.clara.co.uk> writes:
> Does anyone know how long a PostGRES SQL statement can be? In the near
> future, my above-mentioned query will grow to a few hundred SELECTS
> (Phorum) and I'm wondering how it will cope (but too lazy to
> experiment) ???

As of 7.0 there's no hard upper limit.  UNIONing a few hundred SELECTs
might take longer than you really want to wait however ... perhaps some
rethinking of your data model is in order.

			regards, tom lane