Functions for PostgreSQL that mimic POSIX basename and dirname. #complete
http://www.elfsternberg.com/2016/07/13/added-basename-dirname-postgresql-sped-catalogia-lot/
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Elf M. Sternberg
99e40a4c7d
|
7 years ago | |
|---|---|---|
| .gitignore | 8 years ago | |
| LICENSE | 8 years ago | |
| README.rst | 7 years ago | |
| basename.sql | 8 years ago | |
| basename_tests.sql | 8 years ago | |
README.rst
Synopsis
--------
``basename.sql`` contains functions which provide equivalents to the
POSIX functions ``basename`` and ``dirname`` for PostgreSQL, and can be
used in any Postgres SQL command. The functions are written in fairly
standard PL/pgSQL, and should work with any version of PostgreSQL after
version 6.
I make no claim that these functions are SQL/PSM-compliant.
Example
-------
I created these handlers to help with finding nested folders in my music
catalog program, `Catalogia<http://github.com/elfsternberg/catalogia>`.
::
WITH prepped_paths AS (SELECT DISTINCT dirname(path) AS dpath FROM catalog_mp3)
SELECT a.dpath AS parent, b.dpath AS child
FROM prepped_paths AS a, prepped_paths AS b
WHERE a.dpath != b.dpath
AND a.dpath ~ ('^' || b.dpath);
Status
------
**July 12, 2016**: This project is **conditionally complete**. No new
features are being considered, but bug reports will be accepted and
(eventually) acted upon.
LICENSE AND COPYRIGHT NOTICE: NO WARRANTY GRANTED OR IMPLIED
------------------------------------------------------------
Copyright ⓒ 2016 Elf M. Sternberg <elf.sternberg@gmail.com>
Released under The MIT License. Please see the LICENSE file for more
details. All rights not clearly enumerated by the LICENSE are reserved
to the authors.