Re: [GENERAL] ERROR: type " " does not exist

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: [GENERAL] ERROR: type " " does not exist
Дата
Msg-id CANu8FizvgyW+k6ukiW+mHnc0ss1wiDQdh0y43jJ5O=vcdM=Qpw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] ERROR: type " " does not exist  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general


On Mon, Jun 12, 2017 at 4:28 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Jun 12, 2017 at 1:03 PM, Alexander Farber <alexander.farber@gmail.com> wrote:
ERROR:  type " " does not exist at character 149

​Nothing shown would explain what you are seeing.  Of course, white-space issues are really hard to communicate via email.

As a brute-force suggestion I'd say you want to re-write the function one statement at a time to confirm that, one, you are indeed calling the correct function body, and, two figure out the exact statement that is problematic.  I'd do this via copy-paste until the problem statement appears then I'd re-type in the problem statement by hand.

There are probably more efficient ways to do all this but given a lack of experience and a relatively small function I'd spend more effort trying to figure out a better way than just doing it brute force.

David J.


You did not state the O/S you are using, but if it's LINUX, just use vi and do a "set list".
That should reveal any strange characters that might be the cause,

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] ERROR: type " " does not exist
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] ERROR: type " " does not exist