codewinsdotcom/PostgresClientKit

Pull request discussion: Adding PostgresArray type

kkieffer opened this issue · 2 comments

I've created an extension to the library in my own code which may be useful if you'd consider a pull request. One of my data types is an array of SQL values, which there is currently no support for. The code linked here would add that type:

https://gist.github.com/kkieffer/0adadaaa351871d59d08a95d40f67cc3

The user can create an optionalArray and pull the values from it like this:

let postgresArrayValues : [PostgresValue] = try columns[8].optionalArray()?.arrayValues

Then for each value, they can extract the desired type.

The postgresValue for PostgresArray provides a raw value like this:

{"value1","value2","value3"}

Thanks for this suggestion. I need to learn more about arrays in Postgres, and will then reply with my thoughts on this.

@pitfield Any update on this?