Re: Standard syntax?

"Franz J Fortuny" <ffortuny(at)ivsol(dot)com> writes:

> I have been using (with success) this SQL statement in PostgreSQL:
>
> select col1,
> case when col2 = true then
> col3
> else
> col4
> end as colw,
> colM
> where .... etc.
>
> The above syntax, however, does not work for Interbase (6.01). For those who
> have had experience in other SQL servers, is this a "standard" or ANSI 9X
> compatible syntax or should I refrain from such syntax if I want my
> statements to be transportable from SQL Server to SQL Server?

It is not part of SQL92, and I don't think it's part of SQL-3
either. Many databases (PostgreSQL, MSSQL, Oracle, ...) have such
things though, but the syntax is different between them.

If you can do without them, that's what you should try to do.

Tomas