Monday, July 24. 2006
Reverse a text in PostgreSQL
Andreas 'ads' Scherbaum
I'm always searching for a reverse function, so here is the link:
http://www.varlena.com/GeneralBits/53.php
code snippet is available in plperl and plpgsql.
Trackbacks
Trackback specific URI for this entry
No Trackbacks
Comments
Display comments as
(Linear | Threaded)
Using recursion, one can also achieve it with a plain sql function:
create function reverse(text) returns text as $$
select case when length($1)>0
then substring($1, length($1), 1) || reverse(substring($1, 1, length($1)-1))
else '' end $$ language sql immutable strict;
Comments ()
a code from Varlena is not good - there is a few issues - first issue is using a WHILE statement. FOR statement is better - is faster. And you can use a simple and relative fast SQL function
create or replace function rvrs(text)
returns text as $$
select string_agg(substring($1 from i for 1),'')
from generate_series(length($1),1,-1) g(i)
$$ language sql;
Comments ()
Here is one more function to reverse text that uses FOR statement if anybody interested.
create or replace function rev(varchar) returns varchar as $$
declare
_temp varchar;
_count int;
begin
_temp := '';
for _count in reverse length($1)..1 loop
_temp := _temp || substring($1 from _count for 1);
end loop;
return _temp;
end;
$$ language plpgsql immutable;
Comments ()
Quicksearch
Blog Administration
PostgreSQL Buch
Calendar
|
October '19 |
|
||||
| Mon | Tue | Wed | Thu | Fri | Sat | Sun |
| 1 | 2 | 3 | 4 | 5 | 6 | |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 | 31 | |||
Bookmarks
Upcoming Events
Categories
Last Search
Statistics
Last entry: 2019-10-06 00:15
964 entries written
570 comments have been made
9920 visitor(s) this month
258 visitor(s) this week
258 visitor(s) today
14 visitor(s) online
Top Referers
prohoster.info (122445)
sex-tale.ru (49738)
xxx-rasskaz.ru (47335)
sunmebel.ltd.ua (45671)
vk.com (31851)
blogos.kz (30103)
ua.tc (30015)
newporno.xyz (26737)
blox.ua (25371)
2dm.prohoster.info (24280)
sex-tale.ru (49738)
xxx-rasskaz.ru (47335)
sunmebel.ltd.ua (45671)
vk.com (31851)
blogos.kz (30103)
ua.tc (30015)
newporno.xyz (26737)
blox.ua (25371)
2dm.prohoster.info (24280)
Recent Entries
- Certificate expiration date in Ansible
- Sunday, October 6 2019
- Mauerweglauf 2019
- Wednesday, August 21 2019
- Reading data from my Scuba Diving computer after Linux removed IrDA support
- Saturday, July 13 2019
Archives
Syndicate This Blog
Powered by
