Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-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

pgsql-interfaces by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group