Hi list,
I'm trying to create a varchar clone (called varcharci). I have defined new functions called "varcharciin", "varcharciout", "varcharcisend" and "recv", using the "varcharin" etc. definitions (i.e. - builtin functions). I defined the type. Everything works, except that when I try to create a table it fails. This only happens when I try to give maximum length to the type. So the command:
create table foo ( bar varcharci );
succeeds, but
create table foo (bar varcharci(12) );
fails.
What do I need to do in order to get the width specifier into my type? I'm not even sure what function is called in order to say that the type needs a width specifier.
Many thanks Shachar
-- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend