X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 7518852875
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 25 May 2005 12:27:57 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 21193-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 25 May 2005 15:27:52 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.203])
	by svr1.postgresql.org (Postfix) with ESMTP id 3311952872
	for <pgsql-sql@postgresql.org>; Wed, 25 May 2005 12:27:47 -0300 (ADT)
Received: by wproxy.gmail.com with SMTP id 68so286915wri
	for <pgsql-sql@postgresql.org>; Wed, 25 May 2005 08:27:47 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:from:to:subject:date:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:x-mimeole;
	b=PmNagmKKSXorpj8EZlGcrz/5RyDettrmAfPYTDsJHjrkAKBVuiEoBFys5/DwtkTksX4knqHSjge9hAX/BRk5Ww9q8NdjRjUprXKL4+FUPubpC8NKzCqPm95jMs94vDy1kQz6KzyQZPEQdvBRYYjKjfiG1LhwufucYdtHe1Ghd6I=
Received: by 10.54.145.15 with SMTP id s15mr32214wrd;
	Wed, 25 May 2005 08:27:47 -0700 (PDT)
Received: from server ([210.245.59.234])
	by mx.gmail.com with ESMTP id 38sm1421657wrl.2005.05.25.08.27.46;
	Wed, 25 May 2005 08:27:47 -0700 (PDT)
Message-ID: <000501c5613e$592794c0$0201a8c0@server>
From: "hatuan" <hatuan05@gmail.com>
To: <pgsql-sql@postgresql.org>
Subject: Sql select like question.
Date: Wed, 25 May 2005 22:28:00 +0700
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.821 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS, RCVD_BY_IP
X-Spam-Level: 
X-Archive-Number: 200505/215
X-Sequence-Number: 21528

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.