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. As many packages have very basic database configuration cpability, views allow a single table to be used by all software packages. Note that VIEWs can be used anywhere PostgreSQL expects a table. *Anywhere*. A. -- Adam Sherman President & Chief Technologist Tritus Consultant Group Inc. +1 (613) 255-5164 _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
