fix converts.Array

[cybermerlin]

for https://github.com/CSNW/sql-bricks/issues/98

[Suor]

There should be a better solution. This breaks for non int, non text arrays. Also, what's your use case? Why can't you type cast in SQL?

[cybermerlin]

I can't use type cast in SQL because inline SQL used as a template for many types (in JavaScript understand Number or String, as BIGINT or TEXT). For other types may manually formatting SQL-string.

[Suor]

You can do the same you do now only in your own code. Your code very specific anyway:

• only text and integers are supported,
• why text and bigint and not, varchar and int or even float?

This is unmergable.

[cybermerlin]

float = Number in js

[cybermerlin]

as you wish. I use from my repo

[Suor]

Possible solution is to use sql.Array() wrapper and specify type there:

sql.update('category', {tags: sql.Array(tags, 'text')}).where(...)