Re: Insert NULL for ''

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Insert NULL for ''
Дата
Msg-id 828.1055516386@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Insert NULL for ''  (Jonathan Bartlett <johnnyb@eskimo.com>)
Список pgsql-general
Jonathan Bartlett <johnnyb@eskimo.com> writes:
> Could you instead have a function around it?
> into foo (bar) values (myfunction(''))
> Where myfunction maps '' to null.

That would be an easy solution (one of many) if we could make any
changes in the SQL being emitted by the application, but I think
Daniel is saying that he doesn't want to touch the application at all.

            regards, tom lane

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