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, whole thread or download thread mbox)
Lists: pgsql-sql
I have been using (with success) this SQL statement in PostgreSQL:

select col1,
     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?

Best regards,

Franz Fortuny


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-2017 The PostgreSQL Global Development Group