From: hatuan <hatuan05@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Sql select like question.
Date: Wed, 25 May 2005 22:28:00 +0700
Message-ID: <000501c5613e$592794c0$0201a8c0@server> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hatuan05@gmail.com
Subject: Re: Sql select like question.
In-Reply-To: <000501c5613e$592794c0$0201a8c0@server>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox