Re: Using compression on TCP transfer

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: Using compression on TCP transfer
Дата
Msg-id F8BD8234DBE94DB38CBF46348B111649@dell2
обсуждение исходный текст
Ответ на Re: Using compression on TCP transfer  (Olivier Gautherot <ogautherot@gautherot.net>)
Список pgsql-general
Hi!
Thank you.

>If you decide that it's without, you could apply a TRIM in a trigger on each INSERT and UPDATE. Then, you could replace the table by a view of the same name >and implement the TRIM on SELECT there. This way, you don't have to touch anything in the application.
 
How you provide sample code how to create view or othe method test so that my select statement returns data.
 
Currently select in code
 
create table test ( test varchar );
insert into test values ('test');
select * from test where test ='test '; -- note trailing space
 
does not return data.
 
Andrus.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: psql show me the : and ask user input, when running one sql file
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: psql show me the : and ask user input, when running one sql file