http://www.sqle.ru/index.php?action=history&feed=atom&title=PostgreSQL%2FString_Functions%2Fbtrim 2026-05-24T03:13:19Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=PostgreSQL/String_Functions/btrim&diff=4578&oldid=prev 2010-05-26T13:45:56Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://www.sqle.ru/index.php?title=PostgreSQL/String_Functions/btrim&diff=4579&oldid=prev 2010-05-26T10:13:57Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==btrim(&quot;123example 332&quot;, &quot;123&quot;)==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> postgres=#<br /> postgres=# SELECT btrim(&quot;123example 332&quot;, &quot;123&quot;) AS trim_numbers;<br /> trim_numbers<br /> --------------<br /> example<br /> (1 row)<br /> postgres=#<br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==btrim(s [, t]): Returns character string s==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> postgres=# -- btrim(s [, t]): Returns character string s, trimmed on the left and right <br /> of any substrings consisting solely of letters in character string t <br /> (or whitespace, if t is not specified)<br /> postgres=#<br /> postgres=# SELECT btrim(&quot; whitespace example &quot;) AS trim_blanks;<br /> trim_blanks<br /> --------------------<br /> whitespace example<br /> (1 row)<br /> postgres=#<br /> postgres=#<br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==Remove the longest string consisting only of bytes in bytes from the start and==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> postgres=#<br /> postgres=# -- btrim(string bytea, bytes bytea)<br /> postgres=# -- Remove the longest string consisting only of bytes in bytes from the start and<br /> postgres=# -- end of string<br /> postgres=#<br /> postgres=# select btrim(&quot;\\000trim\\000&quot;::bytea, &quot;\\000&quot;::bytea);<br /> btrim<br /> -------<br /> trim<br /> (1 row)<br /> postgres=#<br /> postgres=#<br /> <br /> &lt;/source&gt;</div>

Admin