Re: [GENERAL] PLSQL Question regarding multiple inserts

2004-02-28 Thread Humble Geek
; you dont have duplicate... > > so you would: > > INSERT INTO test ('log', 'message'); > > then > > SELECT * FROM test; > > would give you > > id, log and message. > > > > -- > Greg Patnude / The Digital Demention > 2916 E

[GENERAL] PLSQL Question regarding multiple inserts

2004-02-28 Thread Humble Geek
Hi all. Quick and perhaps silly question, but... I am using Pg 7.3. I am writing a function using pgplsql. This function will perform multiple inserts. Let's say two of the inserts are as follows: -- id is primary key insert into users (id, username) values (nextval('someSeq'),'somename'); -- id