On Jan 6, 9:20 pm, "Stephen C. Gilardi" <squee...@mac.com> wrote:
> On Jan 6, 2009, at 2:27 PM, ssecorp wrote:
>
> > On Jan 6, 8:12 pm, ssecorp <circularf...@gmail.com> wrote:
> >> CREATE TABLE foo (
> >> col1 INTEGER NOT NULL,
> >> col2 VARCHAR(32) NOT NULL,
> >> col3 DATE NOT NULL,
> >> PRIMARY KEY (col1, col2)
> >> );
>
> >> how would I set primary key if it is a combination of 2 keys?
>
> This appears to work:
>
> (sql/create-table :foo
> [:col1 :integer :not :null]
> [:col2 "Varchar(32) :not :null]
> [:col3 "DATE" :not :null]
> ["primary key" "(col1, col2)"])
>
> Can you confirm that?
>
> I think your other examples can be done in a similar way.
>
> --Steve
>
> smime.p7s
> 3KViewDownload
that worked. I will post more tomorrow.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To post to this group, send email to clojure@googlegroups.com
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
-~----------~----~----~----~------~----~------~--~---
