hi everybody.
i have two table as :
CREATE TABLE "public"."tb_section_phones" ( "section_id" INTEGER NOT NULL, "ptype_id" INTEGER NOT NULL, "country_code" SMALLINT DEFAULT 90, "domain_code" SMALLINT,
"number" CHAR(7) NOT NULL, "extension" VARCHAR(6), CONSTRAINT "tb_section_phones_
i am writing a recursive procedure in pl/pgsql.i need to check whether a condition is true in any step of recursive calls.if i get a true response in one call, i wont make other recursive calls anymore, because i get what i need.
if no one gives me a true response, then uppest procedure will return
hi every body.
i have a pl/pgsql function (i want to form it to run correctly) :
CREATE OR REPLACE FUNCTION "public"."ftest" () RETURNS boolean AS$body$declare f boolean; str varchar(100);begin str := '1,5,10'; if exists( select 1 from tb_categories where cat_id in ( str )
hi everybody.
i am writing stored procedures.
lots of them have out parameters.
i dont know how to test them
from an sql query tool(ex: pgAdmin query tool).
i am trying to test them from my program, but it is not so efficient.
i want to test from a query tool.
i can do with procedures withou
hi everybody.i have a sp. i am passing two argument to it.first one : _sort_column --> defines which column will be used in "order by".second : _sort_direction --> define sorting direction(asc or desc).
i writing sp as :CREATE OR REPLACE FUNCTION ftest(_sort_column "varchar", _sort_direction "varch