<div class="Section1"><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Hi,</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">How do I know if a function (or a certain sql syntax) in Postgres is a SQL ANSI Standard, hence it
workson all databases such as MySQL, SQL Server, Oracle…</span></font><p class="MsoNormal"><font face="Verdana"
size="2"><spanstyle="font-size:10.0pt;
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">I noticed that concat, decode, nvl, instr are functions that work for some databases and don’t for
others.</span></font><pclass="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">I only want to use ANSI Standard functions that work everywhere.</span></font><p
class="MsoNormal"><fontface="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">How do I identify them?</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size:10.0pt;
font-family:Verdana">How do I know if a function is specific to Postgres and don’t work for other
databases.</span></font><pclass="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Sorry, I may have asked the same question more than a time</span></font><p class="MsoNormal"><font
face="Verdana"size="2"><span style="font-size:10.0pt;
font-family:Verdana">But I just wanted it to be clear</span></font><p class="MsoNormal"><font face="Verdana"
size="2"><spanstyle="font-size:10.0pt;
font-family:Verdana">I’d appreciate any reply to my question</span></font><p class="MsoNormal"><font face="Verdana"
size="2"><spanstyle="font-size:10.0pt;
font-family:Verdana">Thanks</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size:10.0pt;
font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Pascal </span></font></div>