Gordon Burditt wrote: > [...stuff snipped...] > > MySQL permits (but it's not standard, and available in MySQL 4.1.0 > and later): > > INSERT INTO my.table (somefield) VALUES ('$someval') ON DUPLICATE > KEY UPDATE somefield = '$someval'; > > This is very useful for times when you want to count something (e.g. > SPAM), and if a record doesn't exist, make one with a count of 1. > > I don't know whether something similar is available in PostGres. > > Gordon L. Burditt In Postgres you'd probably create a server-side function to get that effect. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings