Re: Date Time Functions - ANSI SQL ? - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Date Time Functions - ANSI SQL ?
Date
Msg-id Pine.LNX.4.30.0108052336230.11071-100000@peter.localdomain
Whole thread Raw
In response to Re: Date Time Functions - ANSI SQL ?  (Gonzo Rock <GonzoRock@Excite.com>)
Responses Re: Re: Date Time Functions - ANSI SQL ?
List pgsql-sql
Gonzo Rock writes:

> 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...

While it would be an appreciated effort to create such a document (and we
already try to document standards-compliance in other places), it would be
of less practical use than it might seem at first.  Most SQL database
packages implement all kinds of functions that are found nowhere near the
SQL standard.  PostgreSQL has copied a number of these and added aliases
and near-aliases in a number of other cases.  We don't all program in ANSI
C or C++ these days either.  What is portable is a bit of a matter of
experience and research, modulo good code organization so you can replace
the unportable parts easily.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: "Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков
Date:
Subject: Re: Creating foreign key constraint to child table?
Next
From: Peter Eisentraut
Date:
Subject: Re: Fuzzy matching?