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

[Tom Lane]

Barry Hill <[EMAIL PROTECTED]> 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