Received: from redbox.venux.net (redbox.venux.net [216.47.238.10])
	by hub.org (8.9.2/8.9.1) with ESMTP id OAA40253
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 14 Apr 1999 14:48:31 -0400 (EDT)
	(envelope-from matthew@venux.net)
Received: from thunder (net177138.hcv.com [209.153.177.138])
	by redbox.venux.net (Postfix) with SMTP for
	<pgsql-interfaces@postgreSQL.org>
	id D8B582E210; Wed, 14 Apr 1999 14:47:46 -0400 (EDT)
Message-Id: <4.1.19990414140053.0096de40@mail.venux.net>
X-Sender: mhagerty@mail.venux.net
X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 
Date: Wed, 14 Apr 1999 14:47:59 -0400
To: pgsql-interfaces@postgreSQL.org
From: Matthew Hagerty <matthew@venux.net>
Subject: Urgent, bool-to-int patch possible?
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Greetings,

What would be the chances of getting a patch for 6.4.2 to do bool-to-int
conversion?  I need to do a query similar to this:


SELECT * FROM mytable ORDER BY 
int(col1 > 3) + int(col2 < 4) + ... other conditions;

(courtesy of Tom Lane)

Would it be that hard to make a patch to do the conversion?  I would try it
myself but I have no idea where to start looking, and I need this sooner
than I could probably figure it out.

I'm not making demands or stomping my feet, I love postgres and I
understand that it is free software, but if one of you feels really nice... :)

Thanks,
Matthew