search

pgspider / sqlite_fdw

SQLite Foreign Data Wrapper for PostgreSQL
Other
218 stars 37 forks source link

Implement MAC address support #101

Open mkgrgis opened 2 months ago

mkgrgis commented 2 months ago

This PR implements PostgreSQL macaddr and macaddr8 columns support as possible mixed affinity column in SQLite. The nearest affinity selected as integer because of there are many fast operations in SQLite including | and &. After this PR sqlite_fdw will can deal with both 12-34-56-78-9A-BC text , 0x0123456789ABC integer and X'0123456789ABC' blob notations. In this PR also:

mkgrgis commented 2 months ago

@t-kataym, could you please plan review of this ready PR by pgspider team?