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? Best regards, Franz Fortuny
- Re: [SQL] Standard syntax? Franz J Fortuny
- Re: [SQL] Standard syntax? Josh Berkus
- Re: [SQL] Standard syntax? Tomas Berndtsson
- Re: [SQL] Standard syntax? Jie Liang
- Re: [SQL] Standard syntax? Peter Eisentraut
- Re: [SQL] Standard syntax? Tom Lane