Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5KH9Ea05187 for ; Wed, 20 Jun 2001 13:09:14 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from hotmail.com (f96.law8.hotmail.com [216.33.241.96]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5F7bEa09900 for ; Fri, 15 Jun 2001 03:37:14 -0400 (EDT) (envelope-from gente_che_mixa@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 15 Jun 2001 00:37:08 -0700 Received: from 212.216.39.204 by lw8fd.law8.hotmail.msn.com with HTTP; Fri, 15 Jun 2001 07:37:08 GMT X-Originating-IP: [212.216.39.204] From: "Matteo Centenaro" To: pgsql-sql@postgresql.org Subject: Limit and insert Date: Fri, 15 Jun 2001 07:37:08 -0000 Mime-Version: 1.0 Content-Type: text/html; charset=iso-8859-1 Message-ID: X-OriginalArrivalTime: 15 Jun 2001 07:37:08.0036 (UTC) FILETIME=[FB28A840:01C0F56D] X-Archive-Number: 200106/314 X-Sequence-Number: 3599
Hi all,
 is possible that the limit statement dosen't run correctly in this case:
 
Insert into temp
Select * from tab1
Where cod = xxxx
Limit yyy;
 
Thanks in advance !



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.