Re: DOMAIN NEED CAST ?

On Sun, 2003-08-17 at 12:34, ivan wrote:
> Why when i create domain like :
>
> CREATE DOMAIN alias_to_int AS INT;
>
> and then function like :
>
> CREATE FUNCTION func() RETURNS alist_to_int AS ' select 2::int; ' LANGUAGE
> SQL;
>
> and pg can not convert int to aliast_to_int, so i need to create cast for
> all this same types ?

PostgreSQL will not cast your function return results for you.

rbt=# create function func() returns integer as 'select 2::int2'
language sql;
ERROR:  return type mismatch in function: declared to return integer,
returns smallint