Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6U5dRf36462 for ; Mon, 30 Jul 2001 01:39:27 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f6U5dPC15342; Mon, 30 Jul 2001 01:39:25 -0400 (EDT) To: Gonzo Rock cc: pgsql-sql@postgresql.org Subject: Re: Date Time Functions - ANSI SQL ? In-reply-to: <3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net> References: <3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net> Comments: In-reply-to Gonzo Rock message dated "Sun, 29 Jul 2001 21:19:11 -0700" Date: Mon, 30 Jul 2001 01:39:25 -0400 Message-ID: <15339.996471565@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200107/378 X-Sequence-Number: 4192 Gonzo Rock writes: > Are all the date time functions described in the pgSQL docs are > ANSI-SQL or pgSQL extensions? One or the other, yes ;-) EXTRACT() is ANSI, though I think we may accept a few more field keywords than the spec mentions. regards, tom lane