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 f1M9D4x20473 for ; Thu, 22 Feb 2001 04:13:05 -0500 (EST) (envelope-from radek@alter.pl) Received: by mail.alter.pl (Postfix, from userid 500) id EBA405B0A7; Thu, 22 Feb 2001 10:12:53 +0100 (CET) Date: Thu, 22 Feb 2001 10:12:53 +0100 From: Radoslaw Stachowiak To: pgsql-sql@postgresql.org Subject: Re: now() with microsecond granulity needed Message-ID: <20010222101253.F1718@blue.alter.pl> Mail-Followup-To: pgsql-sql@postgresql.org References: <20010220173146.E1718@blue.alter.pl> <12975.982688262@sss.pgh.pa.us> <20010221215416.C1718@blue.alter.pl> <14996.11186.111947.408165@gargle.gargle.HOWL> <12323.982792533@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <12323.982792533@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Wed, Feb 21, 2001 at 04:55:33PM -0500 X-Archive-Number: 200102/335 X-Sequence-Number: 1531 *** Tom Lane [Wednesday, 21.February.2001, 16:55 -0500]: > Hmm, exactly what I was thinking of, except that it returns a text > rather than a timestamp (a strange choice...). But it's implicit casted to timestamp type so i think is good choice to use in DEFAULT clause at this moment. Correct me if I'm wrong. > It seems a little > buggy as well because the formatting of the microseconds part is > wrong --- will fix that, and document it. In 7.1 version? -- radoslaw.stachowiak.........................................http://alter.pl/