[SQL] Sql select like question.

[hatuan]

I use domain in my database
Ex
CREATE DOMAIN ud_id
  AS bpchar(3)
  DEFAULT ''::bpchar
  NOT NULL;

And have table A

CREATE TABLE A
(
    id ud_ma_nt NOT NULL,
    name ud_name,
    CONSTRAINT A_pkey PRIMARY KEY (id)
)

I have a select query Select * from A where id like 'US%'
In pgAdmin i have error : "ERROR:  unsupported type: 136452". But if select
is : Select * from A where id like 'US%'::ud_id, query work well.
So can I use first query in postgre? I don't want to use second query
because i don't know columns 's domain but i know it is char(xx).
Thank in advance. Sorry for my English.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match