pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Matthew Hagerty <matthew@venux.net>
To: pgsql-interfaces@postgreSQL.org
Subject: Urgent, bool-to-int patch possible?
Date: Wed, 14 Apr 1999 14:47:59 -0400
Message-ID: <4.1.19990414140053.0096de40@mail.venux.net> (raw)

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



view thread (3+ messages)  latest in thread

Message-ID: <4.1.19990414140053.0096de40@mail.venux.net>
Permalink:  ../4.1.19990414140053.0096de40@mail.venux.net/
Also on:    postgresql.org/message-id/4.1.19990414140053.0096de40@mail.venux.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: matthew@venux.net
  Subject: Re: Urgent, bool-to-int patch possible?
  In-Reply-To: <4.1.19990414140053.0096de40@mail.venux.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox