X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B156FD1BB90 for ; Tue, 16 Dec 2003 13:28:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 30365-10 for ; Tue, 16 Dec 2003 09:28:26 -0400 (AST) Received: from curie.credativ.org (credativ.com [217.160.209.18]) by svr1.postgresql.org (Postfix) with ESMTP id A1F11D1B463 for ; Tue, 16 Dec 2003 09:28:22 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by curie.credativ.org (Postfix) with ESMTP id 3D02F5626B; Tue, 16 Dec 2003 14:28:10 +0100 (CET) Received: from 192.168.2.126 (dsl-213-023-248-127.arcor-ip.net [213.23.248.127]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by curie.credativ.org (Postfix) with ESMTP id 22A0C56240; Tue, 16 Dec 2003 14:28:09 +0100 (CET) From: Peter Eisentraut To: Olivier Hubaut , Tom Lane Subject: Re: dump and schema Date: Tue, 16 Dec 2003 14:28:07 +0100 User-Agent: KMail/1.5.4 Cc: van Elsacker Frans , pgsql-sql@postgresql.org References: <5.2.1.1.0.20031215163225.02a4c5b8@mail.atbib.be> <13072.1071505327@sss.pgh.pa.us> <3FDED01A.8090009@scmbb.ulb.ac.be> In-Reply-To: <3FDED01A.8090009@scmbb.ulb.ac.be> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200312161428.07339.peter_e@gmx.net> X-Virus-Scanned: by AMaViS at credativ.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/113 X-Sequence-Number: 16279 Olivier Hubaut wrote: > I think this won't get the same result he expects. As I know, the > CURRENT_DATE will always give the current day, not the day you > inserted the row. Your knowledge is incorrect.