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
|
February '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 | |||
Bookmarks
Upcoming Events
Categories
Last Search
Statistics
Last entry: 2019-02-03 14:34
957 entries written
568 comments have been made
26064 visitor(s) this month
335 visitor(s) today
141 visitor(s) online
Top Referers
prohoster.info (122445)
sex-tale.ru (49738)
xxx-rasskaz.ru (47335)
vk.com (30105)
blogos.kz (30103)
ua.tc (30015)
newporno.xyz (26737)
blox.ua (25371)
2dm.prohoster.info (24280)
link.ac (22459)
sex-tale.ru (49738)
xxx-rasskaz.ru (47335)
vk.com (30105)
blogos.kz (30103)
ua.tc (30015)
newporno.xyz (26737)
blox.ua (25371)
2dm.prohoster.info (24280)
link.ac (22459)
Recent Entries
- How long will a 64 bit Transaction-ID last in PostgreSQL?
- Sunday, February 3 2019
- Weather Forecast in openHAB based on OpenWeatherMap, using Ansible
- Friday, January 25 2019
- Install OpenWeatherMap in openHAB, using Ansible
- Thursday, January 24 2019
Archives
Syndicate This Blog
Powered by
