I tried this on the command prompt but got the following error:
admin=> INSERT INTO business_address (street_name, town, county, postcode, county_id, business_name_id) values ('xcasc', 'ascasc', 'ascasc', 'acasc', 2, currval('business_name_business_name_seq'));
ERROR: business_name_business_name_seq.currval is not yet defined in this session
Any ideas as to what is going on.
pgsql-novice by date
|Next:||From: Steinn E. Sigurdarson||Date: 2002-09-23 14:23:34|
|Previous:||From: Norman Khine||Date: 2002-09-23 06:23:15|
|Subject: Re: Subselect query for a multi table insert single query |