Re: [SQL] ANSI Standard

2008-06-26 Thread Montaseri
gt; >> >> >> 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. >> > > In general, I find that the Pg docs pretty clear state what is ANSI >

Re: [SQL] ANSI Standard

2008-06-26 Thread Steve Midgley
At 02:20 AM 6/25/2008, [EMAIL PROTECTED] wrote: Date: Tue, 24 Jun 2008 17:33:11 +0300 From: "Pascal Tufenkji" <[EMAIL PROTECTED]> To: Subject: ANSI Standard Message-ID: <[EMAIL PROTECTED]> Hi, How do I know if a function (or a certain sql syntax) in Postgres is a SQ

Re: [SQL] ANSI Standard

2008-06-24 Thread Richard Broersma
On Tue, Jun 24, 2008 at 7:33 AM, Pascal Tufenkji <[EMAIL PROTECTED]> 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, deco

[SQL] ANSI Standard

2008-06-24 Thread Pascal Tufenkji
Hi, 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 t