subject:"\[SQL\] operator class"

Re: [SQL] operator class

2008-02-27 Thread Tom Lane

"miquel_ibanez" <[EMAIL PROTECTED]> writes: > CREATE TYPE t_cod_t_activ AS ( > cod_t_activ CHAR(10) > ); If you just want an alias for char(10), a domain would probably work better. CREATE TYPE AS is meant for creating multi-field row types. > Does it mean that I cannot create

[SQL] operator class

2008-02-27 Thread miquel_ibanez

Hello I have just started with postgreSQL. I have a file with the following commands : CREATE TYPE t_cod_t_activ AS ( cod_t_activ CHAR(10) ); CREATE TABLE tip_activ ( id_tip_activt_cod_t_activ, des_t_activ t_des_t_activ