Re: ANSI Standard

On Tue, Jun 24, 2008 at 7:33 AM, Pascal Tufenkji <ptufenkji(at)usj(dot)edu(dot)lb> wrote:

> How do I know if a function (or a certain sql syntax) in Postgres is a SQL
> ANSI Standard, hence it works on all databases such as MySQL, SQL Server,
> Oracle…

> I noticed that concat, decode, nvl, instr are functions that work for some
> databases and don't for others.
>
> I only want to use ANSI Standard functions that work everywhere.

Well the problem is that most database do not support that same full
set of ANSI features. So if you design your schema with a wide range
of ansi features, certain ddl will probably not commit or at least
will be ignored on most databases. We database brand has incorporated
a different set of features.

> How do I identify them?

This should get you started :
http://www.postgresql.org/docs/8.3/interactive/features.html

--
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug