Received: from leela.one-2-one.net (leela.one-2-one.net [217.115.142.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fACFeSm11101 for ; Mon, 12 Nov 2001 10:40:29 -0500 (EST) (envelope-from twanger@bluetwanger.de) Received: from [192.168.0.14] (pD9501247.dip.t-dialin.net [217.80.18.71]) by leela.one-2-one.net (8.11.0/8.11.0) with ESMTP id fACFdw214818; Mon, 12 Nov 2001 16:39:58 +0100 Subject: Re: integer attribute 1672 != 1672 From: Markus Bertheau To: Tom Lane , postgres sql list In-Reply-To: <14034.1005579304@sss.pgh.pa.us> References: <1005576429.31390.4.camel@entwicklung01.cenes.de> <14034.1005579304@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/0.99.0 (Preview Release) Date: 12 Nov 2001 16:52:40 +0100 Message-Id: <1005580366.31390.8.camel@entwicklung01.cenes.de> Mime-Version: 1.0 X-Archive-Number: 200111/159 X-Sequence-Number: 5543 Good day, > Grouped views don't really work in any version before 7.1. cenes=> select version(); version --------------------------------------------------------------- PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2 (1 row) cenes=> select distinct partner_id from partner_views; partner_id ------------ 0 1672 0 1670 1672 0 1672 1677 1692 1814 1874 1905 1948 2101 2129 (15 rows) same thing? Markus Bertheau