13 Jan
2013
13 Jan
'13
5:58 a.m.
I thought I understood the s-sql syntax on inserting into an array. Then I tried it. No, I do not understand the s-sql array syntax for an insert-into statement. Does anyone have a simple example? As a sampe: (query (:create-table test2 ((id :type serial) (name :type text) (stuff1 :type int4[]) (stuff1 :type int4[])))) What would be the equivalent s-sql to (query "insert into test2 values (1,'t2','{22,24,21,20}','{{2,4},{6,7}}')") Such that (query (:select (:[] 'stuff2 1 1) :from 'test2 :where (:= 'id 1)) :single) #2A((2 4)) Thank you for any explanations or pointers. Sabra Crolleton