| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Osvaldo Mendoza <polako78(at)hotmail(dot)com> |
| Cc: | pgsql-es-ayuda <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: Consulta |
| Date: | 2010-08-13 17:48:00 |
| Message-ID: | 1281721592-sup-9286@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Excerpts from Osvaldo Mendoza's message of mar ago 10 12:46:06 -0400 2010:
>
> Buenas, necesito haber si existe una funcion para inversion de caracteres de un campo.
>
> Ejemplo:
> Juan Costa --> atsoC nauJ
CREATE OR REPLACE FUNCTION reverse(TEXT) RETURNS TEXT AS $$
SELECT
array_to_string(
ARRAY
( SELECT substring($1, s.i,1) FROM generate_series(length($1), 1, -1) AS s(i) ),
'');
$$ LANGUAGE SQL IMMUTABLE;
Tomada de aquí:
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#LIKE_optimalization
alvherre=# select reverse('Juan Costa');
reverse
------------
atsoC nauJ
(1 fila)
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Linder Poclaba Lazaro | 2010-08-16 11:23:18 | Ayuda con consulta |
| Previous Message | Carlos Joaniquet | 2010-08-13 17:33:38 | Re: Particionamiento y herencia |