Hi everyone:
We have the max function in postgresql so we can run
something like:
select max(my_field) from my_table?
But I can not find a mean function. Can we do:
select mean(my_data_field) from my_table?
Thanks,
qq
__
Do You Yahoo!?
Tired o
I have two tables action and group:
action
id,
name
group:
action_id
rank
I what to select from action table by order by the
rank in the group table.
If I use
select * from action where id in (select action_id
from group order by rank)
The ac
When I was trying to connect my databse with jdbc, I
got the following error message:
org.postgresql.util.PSQLException: Connection
rejected: FATAL: no pg_hba.conf entry for host
"mydomain", user "", database "myDB", SSL off.
When I run in dos console "psql myDB..." it works
fine.
My jdbc c
I have tables create by:
create table address(
id serial PRIMARY KEY,
...);
create table user(
id serial PRIMARY KEY,
name text not NULL,
addressId integer REFERENCES address(id) NOT NULL,
UNIQUE(name)
);
...
I have used the database for sometime and now I would
like to
