@wmfs/pg-concat

Takes an object with parts from table and outputs sql statement.

Usage no npm install needed!

<script type="module">
  import wmfsPgConcat from 'https://cdn.skypack.dev/@wmfs/pg-concat';
</script>

README

pg-concat

Takes an array of parts and returns the necessary PostgreSQL expression to concatenate them.

Usage

const pgConcat = require('pg-concat')

const concatString = pgConcat(
    [
        { columnName: 'incident_no' },
        '/',
        { columnName: 'year', default: 1900 },
    ]
)

// concatString = 'incident_no||'/'||COALESCE(year, 1900)'

Install

$ npm install pg-concat --save

License

MIT