| From: | "tobbe" <tobbe(at)tripnet(dot)se> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | automatic update or insert |
| Date: | 2005-10-20 06:36:24 |
| Message-ID: | 1129790184.351579.302550@g47g2000cwa.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi.
I have a little problem.
In a system of mine i need to insert records into table [tbStat], and
if the records exist i need to update them instead and increase a
column [cQuantity] for every update.
I.e. the first insert sets cQuantity to 1, and for every other run
cQuantity is increased.
Currently i have implemented this as a stored procedure in the plpgsql
language. This means that in my stored procedure i first do a select to
find out if the row exists or not, then i do a insert or update
depending if the row existed.
Unfortunately, stored procedures seems awfully slow. And i need the
application to go faster.
One solution could be to implement the stored procedure in my program
instead. I think that this will be atleast 50% faster than my stored
procedure, so that would be ok.
However, this has made me thinking. Couldn't this be done directly in
SQL?
Brgds Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryce Nesbitt (mailing list account) | 2005-10-20 06:57:18 | Re: casting character varying to integer - order by numeric |
| Previous Message | Tom Lane | 2005-10-20 03:33:14 | Re: casting character varying to integer - order by numeric sort |