deleting function
От | pavunkumar |
---|---|
Тема | deleting function |
Дата | |
Msg-id | 58f0db82-50e0-4c63-a5d9-8640ac61ac34@s1g2000prd.googlegroups.com обсуждение исходный текст |
Ответы |
Re: deleting function
Re: deleting function |
Список | pgsql-general |
Dear Friends I have table called below I need to delete the record by using id value of the table For that I wrote below function create or replace function newd(id integer ) returns void as $$ begin delete from testing where id=$1; end; $$ language 'plpgsql'; Here I call the function as " select newd(100) " But it is deleting every things from the table My doubt is , why it was deleting every thing , even I gave the single value in function . pavunkumar=> \d testing; Table "hospital.testing" Column | Type | Modifiers ---------+-------------------+----------- id | integer | not null name | character varying | address | character varying | Indexes: "testing_pkey" PRIMARY KEY, btree (id)
В списке pgsql-general по дате отправления: