Re: [HACKERS] Re: [PATCHES] ':' and ';' operators

Tom Lane wrote:

>
> > I don't have the SQL standards around here, but they should be the
> > reference,
>
> SQL doesn't address math functions at all, AFAICS. Given that lack,
> the names used in C's <math.h> look OK to me, with the exception that
> I'd rather see abs() than fabs().
>
> regards, tom lane

For what its worth (I'll probably get brow-beaten for even mentioning this :-) ),
the ODBC 2.0 specification allows clients to test ODBC data sources to determine
if the data source has implemented the following:

ABS(numeric),
ACOS(float),
ASIN(float),
ATAN(float),
ATAN2(float1, float2),
CEILING(numeric),
COS(float),
COT(float),
EXP(float),
FLOOR(numeric),
LOG(float),
MOD(integer1, integer2),
SIGN(numeric),
SIN(float),
SQRT(float),
TAN(float),
PI(),
RAND([integer]),
DEGREES(numeric),
LOG10(float),
POWER(numeric, integer),
RADIANS(numeric),
ROUND(numeric, integer),
TRUNCATE(numeric, integer)

Anways, thats the list for ODBC 2.0 -- I'm not sure what ODBC 3.0 has....

Mike