[GENERAL] dynamic sorting...

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

[GENERAL] how to test my stored procedures?

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

[GENERAL] can i use a string in where clause such as "id in (str)"

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 )

[GENERAL] are there static variables in pgsql?

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

[GENERAL] Performance difference between char and int2 columns

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_