Received: from mail.alter.pl (blue.alter.pl [212.244.165.40]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1KFVux16982 for ; Tue, 20 Feb 2001 10:31:57 -0500 (EST) (envelope-from radek@alter.pl) Received: by mail.alter.pl (Postfix, from userid 500) id 987D85B06C; Tue, 20 Feb 2001 17:31:46 +0100 (CET) Date: Tue, 20 Feb 2001 17:31:46 +0100 From: Radoslaw Stachowiak To: pgsql-sql@postgresql.org Subject: now() with microsecond granulity needed Message-ID: <20010220173146.E1718@blue.alter.pl> Mail-Followup-To: pgsql-sql@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-Archive-Number: 200102/308 X-Sequence-Number: 1504 Hello! using now() to init TIMESTAMP fields I got resolution of one second. How can I define DEFAULT in column (TIMESTAMP type) to get higher time-resolution (TIMESTAMP supports microseconds). Please CC the answer to me. -- radoslaw.stachowiak.........................................http://alter.pl/