On Sun, Jan 13, 2013 at 6:58 AM, Sabra Crolleton
<
sabra.crolleton@gmail.com> wrote:
> 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
>