BUG #4056: problem creating function with domain argument

Поиск
Список
Период
Сортировка
От eric melbardis
Тема BUG #4056: problem creating function with domain argument
Дата
Msg-id 200803250053.m2P0r8cf081165@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4056: problem creating function with domain argument  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4056
Logged by:          eric melbardis
Email address:      eric.melbardis@netkitsolutions.com
PostgreSQL version: 8.3.1
Operating system:   windows xp sp 2
Description:        problem creating function with domain argument
Details:

hi when i execute the following script using pgadmin query tool:

--------------------------------

CREATE DOMAIN "dt_0" AS varchar(32)
    NULL;

CREATE DOMAIN "dt_1" AS varchar
    NULL;



CREATE FUNCTION "x1" (IN name dt_0, IN description dt_1)
RETURNS integer
AS $$
SELECT 0;
$$
LANGUAGE SQL
IMMUTABLE
RETURNS NULL ON NULL INPUT;


---------------------------


when i look at the function definition using pgadmin it looks like this:

-- Function: x1(dt_0(36), dt_1)

-- DROP FUNCTION x1(dt_0(36), dt_1);

CREATE OR REPLACE FUNCTION x1("name" dt_0(36), description dt_1)
  RETURNS integer AS
$BODY$
SELECT 0;
$BODY$
  LANGUAGE 'sql' IMMUTABLE STRICT
  COST 100;
ALTER FUNCTION x1(dt_0(36), dt_1) OWNER TO postgres;

--------------------------

if i try to delete it: i get:

an error has occured: tyep modifier is not allowed for type "dt_0"

why is the (36) there????


regards

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: why provide cross type arithmetic operators
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4056: problem creating function with domain argument