| From: | ZioBudda <michel(at)michel(dot)enter(dot)it> |
|---|---|
| To: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | insert or delete |
| Date: | 1998-12-01 21:55:28 |
| Message-ID: | Pine.LNX.4.03.9812012247560.22975-100000@michel.enter.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi, i have this table libro_prestito that contains:
id_libro|id_autore
--------+---------
s1 | 5
n3 | 1
s2 | 2
k1 | 1
n2 | 2
n2 | 3
n2 | 4
n1 | 1
n1 | 4
now i must to update the id_libro column, but with this update I can have
the necessity to delete or insert some new element. My question is : is
better to delete the old reference and then insert the new or what ?
Ok, my english is very very bad. A little example: I must to change
id_libro = 'n2' in 'n3' and change/update old item and (ok, this the
maximum case, but i need one code for all) delete the item
"n2 | 4" and add the item "n2 | 5".
"Il divertimento e' giusto se la scimmia ci prende gusto"
--
Italian Linux Press: http://ziobudda.enter.it/ILP/
--
Morelli 'ZioBudda' Davide Michel - Member of Pluto Linux User Group
michel(at)michel(dot)enter(dot)it - http://ziobudda.enter.it/
Linux Problem? Ask to linux(at)media(dot)dsi(dot)unimi(dot)it
"/dev/ziobudda: access to /var/tmp/beer denied, use /var/adm/pineapple"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anatoly K. Lasareff | 1998-12-02 07:22:23 | Re: [GENERAL] Dividing Money |
| Previous Message | ZioBudda | 1998-12-01 21:47:45 | an item or not? |