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
signature.asc
Description: This is a digitally signed message part
