How can I work thru this key problem? - Mailing list pgsql-interfaces

From marc rassbach
Subject How can I work thru this key problem?
Date
Msg-id Pine.BSF.4.05.9907261248380.86691-100000@tandem.milestonerdl.com
Whole thread Raw
Responses Re: [INTERFACES] How can I work thru this key problem?
List pgsql-interfaces
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?




pgsql-interfaces by date:

Previous
From: "Keith A. Jackson"
Date:
Subject: subscribe
Next
From: Peter Mount
Date:
Subject: Re: TQ again