Postgres Pro
Downloads
Home   >   mailing lists

Re: Re[2]: Search (select) options // Max SQL length? - Mailing list pgsql-general

From Tom Lane
Subject Re: Re[2]: Search (select) options // Max SQL length?
Date
Msg-id 22118.966661764@sss.pgh.pa.us
Whole thread Raw
In response to Re[2]: Search (select) options // Max SQL length?  (Barry Hill <barry@penrallt.clara.co.uk>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [General]Postgres Upgrade
Next
From: Bruce Momjian
Date:
Subject: Inprise/Interbase problems