On Tuesday, September 16, 2003, at 05:27 PM, Christopher Browne wrote:
What you want instead is CREATE DOMAIN.
flexreg=# create domain addresstype varchar(50);
The problem here is that you can't tell the difference between a addresstype column and a varchar(50) column in the row description information returned by SELECT. All columns just look like varchar(50). It would be nice if there was something as easy as CREATE DOMAIN but worked more like CREATE TYPE.
Best,
John DeSoi, Ph.D.
---------------------------(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
