0.0.3

Convert 0.0.3

• Adds area conversions #5
• Improve comments
• Follow pgrx development

---

Full Changelog: 0.0.2...0.0.3

0.0.2

Additional speed conversion functions and tests. Functions are now immutable so can be used in the definition of a generated column.

0.0.1

Convert 0.0.1

🎉 Initial release! 🎉

The initial release of the convert Postgres extension includes 15 functions covering four types of conversions.

Results below from this query using PgDD.

SELECT s_name || '.' || f_name AS function_name,
        argument_data_types,
        description
    FROM dd.functions
    WHERE s_name = 'convert'
    ORDER BY f_name
;

Distance

┌───────────────────────┬─────────────────────────────┬────────────────────────────────────────────┐
│     function_name     │     argument_data_types     │                description                 │
╞═══════════════════════╪═════════════════════════════╪════════════════════════════════════════════╡
│ convert.dist_ft_to_m  │ feet double precision       │ Distance conversion - feet to meters       │
│ convert.dist_ft_to_mi │ feet double precision       │ Distance conversion - feet to miles        │
│ convert.dist_km_to_m  │ kilometers double precision │ Distance conversion - kilometers to meters │
│ convert.dist_km_to_mi │ kilometers double precision │ Distance conversion - kilometers to miles  │
│ convert.dist_mi_to_ft │ miles double precision      │ Distance conversion - miles to feet        │
│ convert.dist_mi_to_km │ miles double precision      │ Distance conversion - miles to kilometers  │
│ convert.dist_m_to_ft  │ meters double precision     │ Distance conversion - meters to feet       │
│ convert.dist_m_to_km  │ meters double precision     │ Distance conversion - meters to kilometers │
│ convert.dist_m_to_mi  │ meters double precision     │ Distance conversion - meters to miles      │
└───────────────────────┴─────────────────────────────┴────────────────────────────────────────────┘

Power

┌────────────────────────────┬────────────────────────┬────────────────────────────────┐
│       function_name        │  argument_data_types   │          description           │
╞════════════════════════════╪════════════════════════╪════════════════════════════════╡
│ convert.power_dbm_to_watts │ dbm double precision   │ Power conversion: dBm to Watts │
│ convert.power_watts_to_dbm │ watts double precision │ Power conversion: Watts to dBm │
└────────────────────────────┴────────────────────────┴────────────────────────────────┘

Speed

┌───────────────────────────┬──────────────────────────────────────┬─────────────────────────────────────────────────────────────┐
│       function_name       │         argument_data_types          │                         description                         │
╞═══════════════════════════╪══════════════════════════════════════╪═════════════════════════════════════════════════════════════╡
│ convert.speed_kmhr_to_mph │ kilometers_per_hour double precision │ Speed conversion - kilometers per hour to miles per hour    │
│ convert.speed_kmhr_to_m_s │ kmhr double precision                │ Speed conversion - kilometers per hour to meters per second │
│ convert.speed_mph_to_kmhr │ miles_per_hour double precision      │ Speed conversion - miles per hour to kilometers per hour    │
└───────────────────────────┴──────────────────────────────────────┴─────────────────────────────────────────────────────────────┘

Time to travel

┌────────────────────────┬────────────────────────────────────────────────────┬───────────────────────────────────────────────────┐
│     function_name      │                argument_data_types                 │                    description                    │
╞════════════════════════╪════════════════════════════════════════════════════╪═══════════════════════════════════════════════════╡
│ convert.ttt_meters_m_s │ length_meters double precision, meters_per_second …│ TTT = Time To Travel.  Input: Meters and Meters p…│
│                        │…double precision                                   │…er Second (m_s). Returns Seconds.                 │
└────────────────────────┴────────────────────────────────────────────────────┴───────────────────────────────────────────────────┘