The full text search of postgres is not support Chinese, who can give me some
advises?
use these sqls:
CREATE TABLE big(id serial, name text);
CREATE TABLE sm(id serial, big_id integer, name text);
INSERT into big (id, name) VALUES (1, 'big1');
INSERT into big (id, name) VALUES (2, 'big2');
INSERT into sm(id, big_id, name)VALUES (2, 1, 'sm1');
INSERT into sm(id, big_id, name)VALU
thanks , this is a example of my application.
the ans is here, http://www.postgresql.org/docs/9.0/static/xaggr.html
sql command:
CREATE AGGREGATE array_accum (anyelement)
(
sfunc = array_append,
stype = anyarray,
initcond = '{}'
);
SELECT r.role_name, array_accum(permission) f
I have two table:
CREATE TABLE roles(role_name varchar(255) primary key);
CREATE TABLE roles_permissions(permission varchar(100), role_name varchar(100));
here is result by :
SELECT * from roles;
role_name
---
role1
role2
(2 rows)
here is result by :
SELECT * from roles_per
At 2011-01-12 23:22:40，"Bill Moran" wrote:
>In response to zab08 :
>
>> we have e test db server, we use jdbc to contect.
>> but after a whie, The test db server can not accept connect.
>>
>>
>> useps aux | grep postgrescommand :
>> po
we have e test db server, we use jdbc to contect.
but after a whie, The test db server can not accept connect.
useps aux | grep postgrescommand :
postgres 16904 0.0 0.0 46036 3948 ?S17:03 0:00
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
postgres 16906 0.0 0.0 4614
thank you, I install postgres from source, and use --with-openssl.
when I install sysbench-0.4.8, after the make command:
/usr/bin/ld: warning: libssl.so.6, needed by /opt/PostgreSQL/9.0/lib/libpq.so,
not found (try using -rpath or -rpath-link)
/usr/bin/ld: warning: libcrypto.so.6, needed by
/opt/PostgreSQL/9.0/lib/libpq.so, not found (try using -rpath or -
when I install sysbench-0.4.8, after the make command:
/usr/bin/ld: warning: libssl.so.6, needed by /opt/PostgreSQL/9.0/lib/libpq.so,
not found (try using -rpath or -rpath-link)
/usr/bin/ld: warning: libcrypto.so.6, needed by
/opt/PostgreSQL/9.0/lib/libpq.so, not found (try using -rpath or -
(SELECT * from mydata,city WHERE mydata.sample = 1 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
basen not in ('A', 'T', 'G','C'))
INTERSECT
(SELECT * from mydata,city WHERE mydata.sample = 2 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
base
I use this command to compile the libpq.c.
cc -I /opt/PostgreSQL/8.4/include -o libpq libpq.c -L /opt/PostgreSQL/8.4/lib
-lpq
but I get these error:
/usr/bin/ld: warning: libssl.so.4, needed by /opt/PostgreSQL/8.4/lib/libpq.so,
not found (try using -rpath or -rpath-link)
/usr/bin/ld: warning:
thanks for share paper of GridSQL or others!
13 matches
Mail list logo
