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 work
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 date_trunc('month','now'::datet
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 '1998-
At 15:45 +0200 on 21/10/98, Memphisto wrote:
> I'm terrible sorry, I meant to type login_start and no login_time which is
> and intervallum. Thanks again for your help.
By the way, I was thinking, and my WHERE clause may not catch datetimes
which are on Aug 31, 1998, in the middle of the day.
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
On Wed, 21 Oct 1998, Herouth Maoz wrote:
> At 15:45 +0200 on 21/10/98, Memphisto wrote:
>
>
> > I'm terrible sorry, I meant to type login_start and no login_time which is
> > and intervallum. Thanks again for your help.
>
> By the way, I was thinking, and my WHERE clause may not catch datetim
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 month'::re
> 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 c
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
8|
Hello,
I would like to know if there is a way to access a postgress database
through a CORBA environment.
Any suggestions for a further reading on this topic would be appreciated.
Thanks.
---
On Wed, 21 Oct 1998, Henrik Pedersen wrote:
// When i do a :
//
// ./psql -c "select count(vnr),enr from votes where cnr=1 group by enr"
// vote
// This is almost what i want, execpt that i want the result to be
// ordered by count, instead og enr. so that the entry, which got most
// votes is
14 matches
Mail list logo
