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

Re: [INTERFACES] How can I work thru this key problem?

From: Jeffrey Lyon <lyonj(at)em-systems(dot)com>
To: marc rassbach <marc(at)tandem(dot)milestonerdl(dot)com>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] How can I work thru this key problem?
Date: 1999-07-26 17:39:38
Message-ID: Pine.LNX.4.04.9907261336020.18963-100000@helium.em-systems.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-sql
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?
> 
> 
> 


In response to

pgsql-interfaces by date

Next:From: marc rassbachDate: 1999-07-26 17:50:22
Subject: How can I work thru this key problem?
Previous:From: Peter MountDate: 1999-07-26 17:17:03
Subject: Re: TQ again

pgsql-sql by date

Next:From: marc rassbachDate: 1999-07-26 17:50:22
Subject: How can I work thru this key problem?
Previous:From: Dan WilsonDate: 1999-07-26 13:52:30
Subject: Re: [GENERAL] escaping wildcard chars

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