Revision 10855
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 480 | 480 |
|
| 481 | 481 |
|
| 482 | 482 |
-- |
| 483 |
-- Name: rm_version_suffix(varchar(255)); Type: FUNCTION; Schema: public; Owner: - |
|
| 484 |
-- |
|
| 485 |
|
|
| 486 |
|
|
| 487 |
|
|
| 488 |
|
|
| 489 |
-- |
|
| 483 | 490 |
-- Name: source_by_shortname(varchar(255)); Type: FUNCTION; Schema: public; Owner: - |
| 484 | 491 |
-- |
| 485 | 492 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1035 | 1035 |
|
| 1036 | 1036 |
|
| 1037 | 1037 |
-- |
| 1038 |
-- Name: rm_version_suffix(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 1039 |
-- |
|
| 1040 |
|
|
| 1041 |
CREATE FUNCTION rm_version_suffix(name text) RETURNS text |
|
| 1042 |
LANGUAGE sql IMMUTABLE |
|
| 1043 |
AS $_$ |
|
| 1044 |
SELECT regexp_replace($1, '\..*$', '') |
|
| 1045 |
$_$; |
|
| 1046 |
|
|
| 1047 |
|
|
| 1048 |
-- |
|
| 1038 | 1049 |
-- Name: source_by_shortname(text); Type: FUNCTION; Schema: public; Owner: - |
| 1039 | 1050 |
-- |
| 1040 | 1051 |
|
Also available in: Unified diff
schemas/vegbien.sql: added rm_version_suffix()