Hello Andreas,
You could try with this:
> insert into table1 (authorid, lastname, firstname)
> values (nextval('s_authors'), 'Meyers', 'Scott');
INSERT INTO table1(authorid, lastname, firstname)
VALUES (null, 'Meyers', 'Scott');
> insert into table2 (authorid, title, subtitle)
> values (currval
Hi Andreas!
Andreas Bauer wrote:
In my postgres database, the value of the
insert into command of the table 2 is
currval(sequence).There are severally such insert into
commands back-to-back:
insert into table1 (authorid, lastname, firstname)
values (nextval('s_authors'), 'Meyers', 'Scott');
Fifield,
Tuesday, September 24, 2002, 5:48:47 PM, you wrote:
FM> I need a way to tell if a column value is set, I don't care if it is text or
FM> a number I just need a way to tell if there is a value set. Is there a way
FM> to do this?
If column can contain NULL values, you can do it with IS N
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 10:43 AM
To: Fifield, Mike
Subject: Re: Value
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must
