I have been using (with success) this SQL statement in PostgreSQL:
case when col2 = true then
end as colw,
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?
pgsql-sql by date
|Next:||From: Josh Berkus||Date: 2000-10-12 17:54:07|
|Subject: Re: Standard syntax?|
|Previous:||From: Jie Liang||Date: 2000-10-12 17:36:20|
|Subject: Re: if else query help|