Adam Sherman writes: > On 03/18/2002 04:17:28 PM -0600, Bruce Cannon wrote: >> Preliminary suggestion is to create a view within the database. This >> will >> likely work, but will effectively double the size of my table. We have >> plenty of server (dual PIII/866 with all the trimmings) but if there's >> another way I'd sure like to find it. > > It will not increase the size of the able, as there is no data > duplication. You are effectively translating the incoming query into the > proper select statement on the fly.
I'd be very suprised is pg's query optimizer will be able to optimized a select view in this case to anything other than a table scan, as opposed to an index lookup. This is not a practical solution. -- Sam _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
