-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martijn van Oosterhout wrote:
After you've done the insert on the address table, you can use
currval('address_id_seq') (or equivalent) to get the ID. Ofcourse you have
to have used nextval() for the original insert.
Hope this helps,
..going to
Hi,
I have two tables,
Table A: item_id
Table B: item_id, ref_code
and i want to list all ref_codes in table B that are not referenced by
Table A.
Table A has about 3million records./ table B 200
What is the best way to do that ?
Thanks
Alex
---(end of
On Sunday 09 November 2003 03:13, Martijn van Oosterhout wrote:
After you've done the insert on the address table, you can use
currval('address_id_seq') (or equivalent) to get the ID. Ofcourse you
have to have used nextval() for the original insert.
What if someone else inserts another address
Scott Chapman [EMAIL PROTECTED] writes:
On Sunday 09 November 2003 03:13, Martijn van Oosterhout wrote:
After you've done the insert on the address table, you can use
currval('address_id_seq') (or equivalent) to get the ID. Ofcourse you
have to have used nextval() for the original insert.
On Sun, Nov 09, 2003 at 10:26:51AM -0800, Scott Chapman wrote:
On Sunday 09 November 2003 03:13, Martijn van Oosterhout wrote:
After you've done the insert on the address table, you can use
currval('address_id_seq') (or equivalent) to get the ID. Ofcourse you
have to have used nextval() for
Hello,
Can you please help me in understanding how constants are stored in
postgresql and how the Datum data structure is used for the same.
Thanks
Shalu
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
Hello,
Can you please help me in understanding how constant values are stored in
postgresql.
What is the Datum Data Structue and how is it used?
Thanks
Shalu Gupta
---(end of broadcast)---
TIP 7: don't forget to increase your free space map