Revision 13957
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 4439 | 4439 |
-- Name: spanish_date_words(); Type: FUNCTION; Schema: util; Owner: - |
| 4440 | 4440 |
-- |
| 4441 | 4441 |
|
| 4442 |
CREATE FUNCTION spanish_date_words() RETURNS replacement[]
|
|
| 4442 |
CREATE FUNCTION spanish_date_words() RETURNS hstore
|
|
| 4443 | 4443 |
LANGUAGE sql IMMUTABLE |
| 4444 | 4444 |
AS $$ |
| 4445 |
SELECT '{
|
|
| 4446 |
"(de,)"
|
|
| 4447 |
,"(al,-)"
|
|
| 4448 |
,"(enero,January)"
|
|
| 4449 |
,"(febrero,February)"
|
|
| 4450 |
,"(marzo,March)"
|
|
| 4451 |
,"(abril,April)"
|
|
| 4452 |
,"(mayo,May)"
|
|
| 4453 |
,"(junio,June)"
|
|
| 4454 |
,"(julio,July)"
|
|
| 4455 |
,"(agosto,August)"
|
|
| 4456 |
,"(septiembre,September)"
|
|
| 4457 |
,"(setiembre,September)"
|
|
| 4458 |
,"(octubre,October)"
|
|
| 4459 |
,"(noviembre,November)"
|
|
| 4460 |
,"(diciembre,December)"
|
|
| 4461 |
}'::util.replacement[]
|
|
| 4445 |
SELECT ' |
|
| 4446 |
de => ""
|
|
| 4447 |
,al => -
|
|
| 4448 |
,enero => January
|
|
| 4449 |
,febrero => February
|
|
| 4450 |
,marzo => March
|
|
| 4451 |
,abril => April
|
|
| 4452 |
,mayo => May
|
|
| 4453 |
,junio => June
|
|
| 4454 |
,julio => July
|
|
| 4455 |
,agosto => August
|
|
| 4456 |
,septiembre => September
|
|
| 4457 |
,setiembre => September
|
|
| 4458 |
,octubre => October
|
|
| 4459 |
,noviembre => November
|
|
| 4460 |
,diciembre => December
|
|
| 4461 |
'::hstore
|
|
| 4462 | 4462 |
$$; |
| 4463 | 4463 |
|
| 4464 | 4464 |
|
Also available in: Unified diff
schemas/util.sql: spanish_date_words(): switched to using hstore because this is better for the algorithm that will translate these