[GENERAL] Completely transparent casts

[Joachim Zobel]

Hi.

I have a 
CREATE TYPE ccnumber AS (
  length    SMALLINT,
  tail      VARCHAR(4),
  encrypt   TEXT
);
for credit card number storage. I would like this to be completely
transparent. However I can not get it to be a drop in replacement for a
text type, no matter what casts I create. I always have to do something
like

CREATE TABLE cc_test (
  test  ccnumber
);

INSERT INTO cc_test(test) VALUES (to_ccnumber('1234567890128'));

SELECT ''||test, test FROM cc_test;

Is there a trick I did not find yet?

Sincerely,
Joachim

-- 
"... ein Geschlecht erfinderischer Zwerge, die fuer alles gemietet werden 
koennen."                            - Bertolt Brecht - Leben des Galilei 


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster