Re: Array constructor requires one argument

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Array constructor requires one argument
Дата
Msg-id 10359.1168376961@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Array constructor requires one argument  (Joe Conway <mail@joeconway.com>)
Ответы Re: Array constructor requires one argument  (David Fetter <david@fetter.org>)
Re: Array constructor requires one argument  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Joe Conway <mail@joeconway.com> writes:
> Unless we can convince ourselves that array-of-UNKNOWN is not dangerous,
> I don't think this is easily solved.

One possibility that might handle Martijn's problem is to allow the
construct

    ARRAY[]::type[]

that is, you can have an empty ARRAY construct only if you immediately
cast it to a specific array type.  The application typically knows what
type the data is anyway, and if it just always plasters on the cast then
the syntax would work regardless of whether there are any elements or not.

            regards, tom lane

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

Предыдущее
От: Tony Caduto
Дата:
Сообщение: Re: is there a tracking trace tool like the "SQL Analizer
Следующее
От: Jonathan Hedstrom
Дата:
Сообщение: Re: ERROR: invalid memory alloc request size, and others