Re: [GENERAL] jdbc + postgres

1998-10-21 Thread Przemyslaw Bak
On Tue, 20 Oct 1998, Peter T Mount wrote: Message:Connection failed: java.net.ConnectException: Connection refused This seems to be the most common problem ;-) You are not running the backend with the -i arg, which turns on tcp/ip. Thank you. Two characters more and everything works

[GENERAL] datetime problems

1998-10-21 Thread Memphisto
I'd like to issue a query that lists all the rows of a table whose 'date' columns(its type is datetime) is falls in a month, i.e. these rows were inserted in , say August. How can I do that? When I bugged with that problem I found an interesting bug: elmu= select

[GENERAL] That bug I mention in my prev. letter

1998-10-21 Thread Memphisto
I'm not sure if it's a real bug, it might be intentional, it's in connection with the daylights saving time. Sebestyén Zoltán AKA Memphisto It all seems so stupid, it

Re: [GENERAL] datetime problems

1998-10-21 Thread Herouth Maoz
At 13:50 +0200 on 21/10/98, Memphisto wrote: I'd like to issue a query that lists all the rows of a table whose 'date' columns(its type is datetime) is falls in a month, i.e. these rows were inserted in , say August. How can I do that? SELECT * FROM the_table WHERE the_date BETWEEN

Re: [GENERAL] aggregate question

1998-10-21 Thread Sferacarta Software
Hello Ulf, mercoledì, 21 ottobre 98, you wrote: UM I posted the questions below a few days ago to the SQL list, but UM apparently there is nobody there who can help -- maybe I'm luckier in UM this list? :-) UM -- UM I'm a

Re: [GENERAL] datetime problems

1998-10-21 Thread Herouth Maoz
At 17:14 +0200 on 21/10/98, Memphisto wrote: Another problem. I issued the following query: select * from annex_log where login_start between (select date_trunc('month','now'::datetime)) and (select date_trunc('month','now'::datetime)) + timespan('1

Re: [GENERAL] datetime problems

1998-10-21 Thread Memphisto
Probably because the parentheses are not balanced in the first query. But why the subqueries, anyway? Why not simply: SELECT * FROM annex_log WHERE login_start BETWEEN date_trunc('month','now'::datetime) AND ( date_trunc('month','now'::datetime) + '1 month'::timespan);

RE: [GENERAL] questions

1998-10-21 Thread Jackson, DeJuan
2 questions. 1)Hi, I have this 2 tables: esame= select * from libro_autore\g id_libro|id_autore +- s1 |5 n3 |1 n2 |2 n1 |1 n1 |4 and esame= select * from autore\g cognome|nome

Re: [GENERAL] datetime problems

1998-10-21 Thread Herouth Maoz
At 17:48 +0200 on 21/10/98, Memphisto wrote: Noted, thanks. I'm a newbie in postgreSQL and happy that these types and functions exist, but I think the documentation is a bit spartan(lacks a lot of pieces of information) and depend on those bits that are there in the documentation. The

[GENERAL] Problem with getting the right order

1998-10-21 Thread Henrik Pedersen
I have a datbase that look like this: vnr|cnr|enr| ip|dato ---+---+---+---+-- 1| 1| 17|195.192.136.223|1998-10-14 02:30:18+02 2| 1| 1|195.192.136.164|1998-10-14 02:33:03+02 5| 1| 13|195.192.136.173|1998-10-14 02:49:24+02