Search Postgresql Archives

Re: help with a procedure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




2014-06-05 9:32 GMT-06:00 Carlos Carcamo <eazyduiz@xxxxxxxxx>:
Hi everyone, I wonder if you could help me with a procedure that I would like to perform in postgresql.

I have an insert query like this:

INSERT INTO products (product_id, description, price, qty, ...) values ('01', 'some description', 10.15, 5, ...)

then if there is no problem, perform another query like:

INSERT INTO store(store_id, description, price, qty, ...) values ('02', 'some description', 10.15, 5, ...)

So the second query depends of the first query, if the first one succeed the second will perform the second insert

I would like to do something like:

SELECT myProcedure(product_id, p_description, price, qty, store_id, store_description );

waiting for a response from procedure, maybe true or false.

Thanks in advance...



--
"El desarrollo no es material es un estado de conciencia metal"

Sorry,  the second query looks like:
INSERT INTO store(store_id, description, product_id, price, qty, ...) values ('02', 'some description', '01', 10.15, 5, ...)

--
"El desarrollo no es material es un estado de conciencia metal"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux