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