From: | newsuser(at)linux2(dot)johnmckown(dot)net (John McKown) |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Simple search question |
Date: | 2000-06-13 01:09:11 |
Message-ID: | slrn8kb2dm.3rr.newsuser@linux2.johnmckown.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Tue, 13 Jun 2000 09:42:01 +1000, Alex <gliathit(at)ihug(dot)com(dot)au> wrote:
]>Hi,
]> after running a script which performs an insert, a new tuple is
]>created, and a serial number is generated for it. I want to write the
]>new tuple data back to the screen, including the new serial number.
]> My question is, do I have to do a search for the tuple just inserted in
]>order to get the data back again? I am thinking there must be a faster,
]>more efficient way.
]>Thanks,
]>Alex
What language is your "script" written in? Based on some previous posts,
I guess you're talking about a PHP script. How did you add the tuple?
I'd guess with a pg_Exec(connect_id,"INSERT ...."). From reading the doc,
I think that you can get the row just inserted by using the pg_fetch_row()
function, passing it the result from the pg_Exec and asking for row 0.
I have not yet gotten anything running with PHP (lack of time to "play"),
so I can't test this. If it doesn't work, I'd try using pg_GetLastOid()
to get the OID of the inserted row. The use the pg_Exec and SELECT
* WHERE OID=oid-value, followed by pg_fetch_row().
Just some thoughts.
John
From | Date | Subject | |
---|---|---|---|
Next Message | Alex | 2000-06-13 02:15:17 | Re: Simple search question |
Previous Message | Jesus Aneiros | 2000-06-13 01:01:49 | Re: Outer join in postgresql |