From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
---|---|
To: | "Olivier Gautherot" <ogautherot(at)gautherot(dot)net> |
Cc: | "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Using compression on TCP transfer |
Date: | 2020-04-05 15:57:36 |
Message-ID: | F8BD8234DBE94DB38CBF46348B111649@dell2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-04-05 16:13:11 | Re: psql show me the : and ask user input, when running one sql file |
Previous Message | David G. Johnston | 2020-04-05 14:51:04 | Re: psql show me the : and ask user input, when running one sql file |