From: Richard Huxton <dev@archonet.com>
To: "Graham" <graham@digitalplanit.com>, <pgsql-sql@postgresql.org>
Subject: Re: Conversion Problem
Date: Thu, 13 Nov 2003 14:40:11 +0000
User-Agent: KMail/1.5
References: <0fc401c3a9e1$2e6ee0a0$6864a8c0@GVICKRAGE>
In-Reply-To: <0fc401c3a9e1$2e6ee0a0$6864a8c0@GVICKRAGE>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200311131440.11688.dev@archonet.com>

On Thursday 13 November 2003 12:25, Graham wrote:
> Apologies as this probably isn't really for this list but...
>
> In postgresql you can execute a statement such as:
>
> SELECT 1 > 2;
>
> And it would return 'f'
>
> Does anyone know if you can do this in SQL Server as I have to do a
> conversion of some prewritten SQL code.

If you look here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_oa-oz_3qpf.asp

"Unlike other SQL Server data types, a Boolean data type cannot be specified 
as the data type of a table column or variable, and cannot be returned in a 
result set."

Generally you'd use a BIT type instead of a boolean, but that's not going to 
help you here. I'm not even sure if you can use a boolean expression in the 
column-list part of a select.

The only thing I can think of is to use a case:
  SELECT WHEN 1>2 THEN 1 ELSE 0 END;

As to why MSSQL doesn't support booleans, you could try asking their tech 
support, but I wouldn't get your hopes up.
-- 
  Richard Huxton
  Archonet Ltd