Hello all,
i'm in the need to create a boolean datatype which returns an integer
instead of the usual 't'/'f'. Before anyone starts to point me at
casts: it's a lot overhead to cast some hundred occurances beside the
source of trouble, if you forget one.
And so i asked myself, if there is an easier way than my current
approach. Right now i'm creating input/output functions, the datatype
and a lot of casts and operators (350 lines SQL) just to get another
output:
CREATE FUNCTION boolean2_in(cstring) RETURNS boolean2 AS 'boolin' LANGUAGE internal STRICT;
CREATE FUNCTION boolean2_out(boolean2) RETURNS cstring AS 'int2out' LANGUAGE internal STRICT;
CREATE FUNCTION boolean2_recv(internal) RETURNS boolean2 AS 'boolrecv' LANGUAGE internal STRICT;
CREATE FUNCTION boolean2_send(boolean2) RETURNS bytea AS 'boolsend' LANGUAGE internal STRICT;
CREATE TYPE boolean2 ( input = boolean2_in, output = boolean2_out, receive = boolean2_recv, send = boolean2_send,
internallength= 1, alignment = char, storage = plain, passedbyvalue
);
CREATE CAST (boolean2 AS boolean) WITHOUT FUNCTION AS ASSIGNMENT;
CREATE CAST (boolean AS boolean2) WITHOUT FUNCTION AS ASSIGNMENT;
... and so on.
Can i have this in an easier way?
Kind regards
-- Andreas 'ads' Scherbaum
German PostgreSQL User Group
