Thread: How can I work thru this key problem?

I am using
6.5 postgresql
DBD pg 0.91
DBI 1.08

I have a table that looks like:

create table exampletable (
keyiwant      int4 default nextval('thenextkey') not null,
otherinfo     varchar(20)
);

When I place, oh say the string "Whatsmyid" into exampletable, I'd like to
be able to know the value of keyiwant is, without going back and doing a
select keyiwant from exampletable where otherinfo = "Whatsmyid"

Ideas on how I can get to where I want to go?

There's probably a better way, but I do a:

SELECT NEXTVAL('thenextkey') AS n_thenextkey;
INSERT INTO exampletable (keyiwant, otherinfo) VALUES (n_thenextkey,
'somestring');

...and then use n_thenextkey to refer to the newly added tuple.

Jeffrey


On Mon, 26 Jul 1999, marc rassbach wrote:

> I am using
> 6.5 postgresql
> DBD pg 0.91
> DBI 1.08
> 
> I have a table that looks like:
> 
> create table exampletable (
> keyiwant      int4 default nextval('thenextkey') not null,
> otherinfo     varchar(20)
> );
> 
>  
> When I place, oh say the string "Whatsmyid" into exampletable, I'd like to
> be able to know the value of keyiwant is, without going back and doing a
> select keyiwant from exampletable where otherinfo = "Whatsmyid"
> 
> Ideas on how I can get to where I want to go?
> 
> 
>