Thread: re: Help...(summerd@cs.unm.edu)

> Date: Tue, 20 Oct 1998 20:21:08 -0600
> From: Summer <summerd@cs.unm.edu>
> Subject: Help...
>
> I have set up a database using psql and everything has been going pretty
> well. I am storing a relatively significant amount of data in the tables.
> One particular table has about 22000 entries. All of a sudden I cannot get
> any queries to return on this table. Even a simple:
>
> select * from table;
>
> The database actually hangs. I have not encountered this type of problem
> before. Is there some limitation to the size of a table? Is there a way I
> can try and get into the data? The other tables are behaving normally.....
>
> Any suggestions would be greatly appreciated.
>
> Summer
> UNM

The following may not be your problem at all, but it is a mystery I have
encountered on my own:

If one of the fields in your table is one of the datetime type fields, there is
a certain value you can put into it (I forget what the value is -- it may just
be the format -- long time ago) that will be accepted but will wind up trashing
ONLY THAT TABLE.

I think when I did this, it was on a 6.3.1 release.  You didn't give details on
your Postgresql release or execution platform.....

Hope this helps.

cat

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'::datetime);
date_trunc
-----------------------------
Thu Oct 01 00:00:00 1998 CEST
(1 row)

That's OK.

elmu=> select date_trunc('month','now'::datetime) + timespan('1
month'::reltime)
;
?column?
----------------------------
Sat Oct 31 23:00:00 1998 CET
(1 row)

Why not Nov 1?


--------------------------------------------------------------------------------
Sebestyén Zoltán AKA Memphisto        It all seems so stupid,
                    it makes me want to give up.
szoli@neumann.cs.elte.hu        But why should I give up,
                                        when it all seems so stupid?

MAKE INSTALL NOT WAR            And please avoid Necrosoft Widows

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-08-01' AND '1998-08-31';



Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma