Harald Fuchs wrote:
For larger tables where an index search would be useful, check out
pgfoundry.org/projects/prefix:
...
Wow ... yet another enlightment
Thankyou, I realy appreciate
Sincerely
-bino-
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
In article 5a9699850911222009j272071fbi1dd0c40dfdf62...@mail.gmail.com,
Brian Modra epai...@googlemail.com writes:
2009/11/23 Bino Oetomo b...@indoakses-online.com:
Dear All
Suppose I created a database with single table like this :
--start--
CREATE DATABASE bino;
CREATE TABLE
Dear All
Suppose I created a database with single table like this :
--start--
CREATE DATABASE bino;
CREATE TABLE myrecords(record text);
--end
and I fill myrecords with this :
--start--
COPY myrecords (record) FROM stdin;
1
12
123
1234
\.
2009/11/23 Bino Oetomo b...@indoakses-online.com:
Dear All
Suppose I created a database with single table like this :
--start--
CREATE DATABASE bino;
CREATE TABLE myrecords(record text);
--end
and I fill myrecords with this :
--start--
COPY
Dear Sir
Brian Modra wrote:
You can use a plpgsql to do that e.g.
create or replace function getMatchingRecord(vseek text)
returns text as $$
declare
str text;
len integer;
ret text;
...
I Just try your solution , and it's work like a charm
Thankyou for your enlightment
Sincerely