From: | José Soares <jose(at)sferacarta(dot)com> |
---|---|
To: | Matthew Hagerty <matthew(at)venux(dot)net> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: [INTERFACES] Urgent, bool-to-int patch possible? |
Date: | 1999-04-15 13:19:52 |
Message-ID: | 3715E778.7D8ECB99@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
create function int(bool) returns int as
'
begin
IF $1 THEN
RETURN 1;
ELSE
RETURN 0;
END IF;
end;
' language 'plpgsql';
Matthew Hagerty ha scritto:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 1999-04-15 13:42:49 | RE: [INTERFACES] JDBC and Postgres |
Previous Message | José Soares | 1999-04-15 13:11:51 | Re: [INTERFACES] Urgent, bool-to-int patch possible? |