February 2010
2 posts
3 tags
Postgresql count array length
I faced a problem today. I defined the following table:
create table todos (
id integer primary key,
user_id integer references users(id),
priority smallint not null default 5,
category text,
title text not null,
body text not null,
created_on timestamp not null default CURRENT_TIMESTAMP,
created_by integer references users(id),
finish_on timestamp not null default...
3 tags
Clojure contrib.sql timestamp in postgresql
Hi, I’m still playing around with clojure and I wanted to do something with my postgresql database system and I started using clojure.contrib.sql to connect to the database, to execute statements etc…this library is a thin wrapper around JDBC so you need the newest jar from jdbc.postgresql.org and put it on your classpath (java -cp …). You also need clojure-contrib in your class...