Received: from pltn13.pbi.net (mta7.pltn13.pbi.net [64.164.98.8]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6UHchf51741 for ; Mon, 30 Jul 2001 13:38:44 -0400 (EDT) (envelope-from GonzoRock@Excite.com) Received: from charlie2 ([66.121.57.23]) by mta7.pltn13.pbi.net (iPlanet Messaging Server 5.1 (built May 7 2001)) with SMTP id <0GHA00DV8ROHF4@mta7.pltn13.pbi.net> for pgsql-sql@postgresql.org; Mon, 30 Jul 2001 10:38:42 -0700 (PDT) Date: Mon, 30 Jul 2001 10:39:45 -0700 From: Gonzo Rock Subject: Re: Date Time Functions - ANSI SQL ? In-reply-to: <15339.996471565@sss.pgh.pa.us> X-Sender: sbames@postoffice.pacbell.net (Unverified) To: Tom Lane Cc: pgsql-sql@postgresql.org Message-id: <3.0.5.32.20010730103945.00b50ba0@postoffice.pacbell.net> MIME-version: 1.0 X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.5 (32) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT References: <3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net> <3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net> X-Archive-Number: 200107/384 X-Sequence-Number: 4198 At 01:39 AM 7/30/01 -0400, Tom Lane wrote: >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 ;-) Hey Tom, You Clever guy! Yes, One or the other! OK OK! Nothing worse than a programmer who can't be explicit... maybe that's why I struggle so much ;-) QUESTION: I'm trying to find a pgSQL source that documents the Non-Standard pgSQL stuff, the stuff that will break when attempting to execute against mySQL/Oracle/MSSQLServer etc... Immediately: What about the INHERITANCE capabilities... pretty cool but scarry at the same time. (can you tell I'm brand new to SQL and six months late on my current SQL project?) thanks again,