Monthly Archive for December, 2010

Tour 9630 OS 5.0.0.1030 Official from Sprint

Baru saja genap 1 bulan 5.0.0.983 dirilis (11/11/2010), sudah merilis kembali update update OS Tour 9630: versi 5.0.0.1030 pada 12/13/2010

Software For ® Tour (TM) 9630 smartphone

BlackBerry Handheld Software v5.0.0.1675 (Multilanguage)
Package Version: 5.0.0.1675
Consisting of:

  • Applications: 5.0.0.1030
  • Software Platform: 4.2.0.451
  • File name: 9630AMEA_PBr5.0.0_rel1675_PL4.2.0.451_A5.0.0.1030_Sprint_L.P.exe
  • File size: 111.03MB

Note: The Software Platform and Applications version numbers can be found under Options-About screen on the handheld.

Continue reading ‘Tour 9630 OS 5.0.0.1030 Official from Sprint’

Review OS 5.0.0.983 Official (Sprint)

(seperti biasa… buat referensi saya pribadi kalo mau gonta-ganti )

Sudah menggunakan OS 5.0.0.983 ini sejak awal november 2010 kemaren dirilis untuk Tour 9630. Sebelumnya sempat mencicipi OS 5.0.0.975 (Official) + Hybrid Willboy 8.1.

Sudah mulai merasa bosan sama OS ini, jadi kayaknya waktu yang tepat buat kasih dikit… mungkin sambil mulai mempertimbangkan buat ganti OS lagi.

Menurut forum ini dan situs ini, software version 5.0.0.983 Maintenance Release ini memberikan perbaikan pada hal-hal berikut:

Fixes *3 and *7 issues
Fixes data services for international roaming
Fixes for device user interface (UI) stating “contacting wireless network” after provisioning/OMA is completed
International SMS setup/improvements.
Fix for saving contact alert settings (Contact Ringer setup)
Improvements to media, some third party applications, messaging and more.

Continue reading ‘Review OS 5.0.0.983 Official (Sprint)’

Fungsi String: Split Berdasarkan Karakter

Basic SQL, pada , untuk memisahkan menjadi dua. Untuk memecah menjadi dua baris data bisa menggunakan fungsi regexp_split_to_table.

Misal saya mau memisahkan “kaskus/detik” pada field KOLOM berdasarkan karakter “/”

regexp_split_to_table(KOLOM, E'\\/+')

Hasil (2 baris):

kaskus

detik

——————————————-

Menggunakan fungsi . Merupakan fungsi dari , create dulu di postgres.

Mengambil string di depan “/” :

SUBSTR(KOLOM, 1 ,INSTR(KOLOM, '/', 1, 1)-1)

Mengambil string di belakang “/”

SELECT SUBSTR(KOLOM,INSTR(KOLOM, '/', 1, 1)+1)

Porting Fungsi INSTR Oracle ke Postgres

This is just a note on the blog… numpang catatan :p

PORTING FUNGSI INSTR ORACLE KE POSTGRES
 
-------------------
This section contains the code for a set of Oracle-compatible instr functions that you can use to simplify your porting efforts.
 
--
-- instr functions that mimic Oracle's counterpart
-- Syntax: instr(string1, string2, [n], [m]) where [] denotes optional parameters.
--
-- Searches string1 beginning at the nth character for the mth occurrence
-- of string2.  If n is negative, search backwards.  If m is not passed,
-- assume 1 (search starts at first character).
--
 
CREATE FUNCTION instr(varchar, varchar) RETURNS integer AS $$
DECLARE
    pos integer;
BEGIN
    pos:= instr($1, $2, 1);
    RETURN pos;
END;
$$ LANGUAGE plpgsql STRICT IMMUTABLE;
 
CREATE FUNCTION instr(string varchar, string_to_search varchar, beg_index integer)
RETURNS integer AS $$
DECLARE
    pos integer NOT NULL DEFAULT 0;
    temp_str varchar;
    beg integer;
    length integer;
    ss_length integer;
BEGIN
    IF beg_index > 0 THEN
        temp_str := substring(string FROM beg_index);
        pos := position(string_to_search IN temp_str);
 
        IF pos = 0 THEN
            RETURN 0;
        ELSE
            RETURN pos + beg_index - 1;
        END IF;
    ELSE
        ss_length := char_length(string_to_search);
        length := char_length(string);
        beg := length + beg_index - ss_length + 2;
 
        WHILE beg > 0 LOOP
            temp_str := substring(string FROM beg FOR ss_length);
            pos := position(string_to_search IN temp_str);
 
            IF pos > 0 THEN
                RETURN beg;
            END IF;
 
            beg := beg - 1;
        END LOOP;
 
        RETURN 0;
    END IF;
END;
$$ LANGUAGE plpgsql STRICT IMMUTABLE;
 
CREATE FUNCTION instr(string varchar, string_to_search varchar,
                      beg_index integer, occur_index integer)
RETURNS integer AS $$
DECLARE
    pos integer NOT NULL DEFAULT 0;
    occur_number integer NOT NULL DEFAULT 0;
    temp_str varchar;
    beg integer;
    i integer;
    length integer;
    ss_length integer;
BEGIN
    IF beg_index > 0 THEN
        beg := beg_index;
        temp_str := substring(string FROM beg_index);
 
        FOR i IN 1..occur_index LOOP
            pos := position(string_to_search IN temp_str);
 
            IF i = 1 THEN
                beg := beg + pos - 1;
            ELSE
                beg := beg + pos;
            END IF;
 
            temp_str := substring(string FROM beg + 1);
        END LOOP;
 
        IF pos = 0 THEN
            RETURN 0;
        ELSE
            RETURN beg;
        END IF;
    ELSE
        ss_length := char_length(string_to_search);
        length := char_length(string);
        beg := length + beg_index - ss_length + 2;
 
        WHILE beg > 0 LOOP
            temp_str := substring(string FROM beg FOR ss_length);
            pos := position(string_to_search IN temp_str);
 
            IF pos > 0 THEN
                occur_number := occur_number + 1;
 
                IF occur_number = occur_index THEN
                    RETURN beg;
                END IF;
            END IF;
 
            beg := beg - 1;
        END LOOP;
 
        RETURN 0;
    END IF;
END;
$$ LANGUAGE plpgsql STRICT IMMUTABLE;