Skip site navigation (1) Skip section navigation (2)

Standard syntax?

From: "Franz J Fortuny" <ffortuny(at)ivsol(dot)com>
To: "sqllist" <pgsql-sql(at)postgresql(dot)org>
Subject: Standard syntax?
Date: 2000-10-12 17:44:40
Message-ID: 00fb01c03474$193888c0$3167a8c0@chapur (view raw or flat)
Thread:
Lists: pgsql-sql
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



Responses

pgsql-sql by date

Next:From: Josh BerkusDate: 2000-10-12 17:54:07
Subject: Re: Standard syntax?
Previous:From: Jie LiangDate: 2000-10-12 17:36:20
Subject: Re: if else query help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group