How can I work thru this key problem?

From: marc rassbach <marc(at)tandem(dot)milestonerdl(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: How can I work thru this key problem?
Date: 1999-07-26 17:50:22
Message-ID: Pine.BSF.4.05.9907261248380.86691-100000@tandem.milestonerdl.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

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?

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Byron Nikolaidis 1999-07-26 18:01:08 Re: [INTERFACES] Re: TQ again
Previous Message Jeffrey Lyon 1999-07-26 17:39:38 Re: [INTERFACES] How can I work thru this key problem?

Browse pgsql-sql by date

  From Date Subject
Next Message David Rose 1999-07-26 23:00:45 timespan arithmetic
Previous Message Jeffrey Lyon 1999-07-26 17:39:38 Re: [INTERFACES] How can I work thru this key problem?