4 Sep
2011
4 Sep
'11
9:25 a.m.
On Sun, Sep 4, 2011 at 2:12 PM, Antony lisp.linux@gmail.com wrote:
Hi
I was trying to find how to use the 'serial' (auto increment) type through cl-postgres prepared insert statement execution.
According to http://www.postgresql.org/docs/9.0/interactive/datatype-numeric.html#DATATYP... I basically have two choices for defaulting a serial column value
- pass the DEFAULT keyword for the column value
CL-USER> (s-sql:sql (:insert-into 'table :set 'id (:raw "default") 'name "Antony")) "INSERT INTO "table" (id, name) VALUES (default, E'Antony')"
--
Ivan Boldyrev