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
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
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
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
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
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
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);
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
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
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
10 matches
Mail list logo