Paste number 56348: example for dbs

Index of paste annotations: 1

Paste number 56348: example for dbs
Pasted by: phasefx
When:1 year, 4 months ago
Share:Tweet this! | http://paste.lisp.org/+17H8
Channel:#openils-evergreen
Paste contents:
Raw Source | XML | Display As
INSERT INTO actor.usr (profile, ident_type, usrname, home_ou, family_name, passwd, first_given_name, second_given_name, expire_date, suffix) VALUES ('5', '1', 'phasefx2', '4', 'Etheridge', 'demo123', 'Jason', '', '2011-02-21', '');
INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, valid, state, city, street2, county, usr) VALUES ('USA', '1', '30016', 'foo', '1', 'ga', 'covington', '', '', (select last_value from actor.usr_id_seq));
INSERT INTO actor.card (barcode, usr) VALUES ('phasefx2', (select last_value from actor.usr_id_seq))

Annotations for this paste:

Annotation number 1: use currval
Pasted by: phasefx
When:1 year, 4 months ago
Share:Tweet this! | http://paste.lisp.org/+17H8#1
Paste contents:
Raw Source | Display As
which does what I need

Colorize as:
Show Line Numbers
Index of paste annotations: 1

Lisppaste pastes can be made by anyone at any time. Imagine a fearsomely comprehensive disclaimer of liability. Now fear, comprehensively.