Fork me on GitHub
#sql
<
2017-03-20
>
bja15:03:00

@luxbock do you need to access the vectors in queries? if not, you might as well just encode to bytes to and store the bytes

luxbock16:03:34

@bja I don't. I ended up using ARRAY as the type and converting my values to object-array, which is easy enough to convert to and from

shaun-mahood21:03:24

@seancorfield: Is there a way for insert-multi! to take parameters? I've got a couple fields (latitude and longitude) on a whole bunch of records and I want to insert them as a PostGIS point which would take the syntax along the lines of ST_SetSRID(ST_MakePoint(?,?), 4326) - I've been doing stuff like this by just mapping over and using the single insert version - though looking into it a bit more I might have the syntax wrong here as well, I can't seem to find any examples in my own code of using insert! like this so I might be mixing syntax between this and other JDBC statements... either way, I can't seem to find a good example of making sure I've properly parameterized data for an insert like this.

seancorfield21:03:01

I think I would fallback to execute! for that...

seancorfield21:03:52

You could still use a single SQL insert a la insert-multi! but you’d have to generate the SQL string yourself.

shaun-mahood21:03:31

@seancorfield: Ok, that seems along the lines of how I've been doing this kind of thing - thanks!