Received: from tron.marelli.it (tron.marelli.it [139.128.18.2]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA88024 for ; Mon, 21 Feb 2000 09:33:47 -0500 (EST) (envelope-from Rodrigo.Rezende@hortolandia.marelli.it) Received: from boeing.hortolandia.marelli.it (boeing.hortolandia.marelli.it [139.128.108.251]) by tron.marelli.it (8.9.3/8.9.3) with ESMTP id PAA20394 for ; Mon, 21 Feb 2000 15:29:45 +0100 (MET) Received: from hortolandia.marelli.it (intranet.hortolandia.marelli.it [139.128.108.136]) by boeing.hortolandia.marelli.it (8.8.6 (PHNE_14041)/8.8.6) with ESMTP id MAA11776 for ; Mon, 21 Feb 2000 12:32:44 -0300 (SAT) Message-ID: <38B15BE8.4B0BD398@hortolandia.marelli.it> Date: Mon, 21 Feb 2000 12:38:16 -0300 From: Rodrigo Rezende X-Mailer: Mozilla 4.7 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: rule plan string too big Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello all, I ran the command : create view func_stat as select * from func_preench where codfuncionario||text(data)in(select codfuncionario||text(max(data))from func_preench group by codfuncionario); and Postgres return : ERROR: DefineQueryRewrite: rule plan string too big. (State:S0001, Native Code: 11) How can I resolve it?