Crystle Numan wrote:
Dear all:
I am fairly knowledgeable about PostgreSQL but this behaviour is
stumping me. Any help would be wonderful. If you think it is a bug, let
me now and I'll file one.
(select values in DB (date stamps) between Jan 1, 2000 and Jan 1, 2005,
no results)
db_name=#
On Mon, 2005-08-29 at 23:42 +0200, Martijn van Oosterhout wrote:
On Mon, Aug 29, 2005 at 04:48:49PM -0400, Crystle Numan wrote:
Dear all:
I am fairly knowledgeable about PostgreSQL but this behaviour is
stumping me. Any help would be wonderful. If you think it is a bug, let
me now and
Crystle Numan wrote:
Dear all:
I am fairly knowledgeable about PostgreSQL but this behaviour is
stumping me. Any help would be wonderful. If you think it is a bug,
let me now and I'll file one.
(select values in DB (date stamps) between Jan 1, 2000 and Jan 1,
2005, no results)
Dear all:
I am fairly knowledgeable about PostgreSQL but this behaviour is
stumping me. Any help would be wonderful. If you think it is a bug, let
me now and I'll file one.
(select values in DB (date stamps) between Jan 1, 2000 and Jan 1, 2005,
no results)
db_name=# SELECT * from person_detail
On Mon, Aug 29, 2005 at 04:48:49PM -0400, Crystle Numan wrote:
Dear all:
I am fairly knowledgeable about PostgreSQL but this behaviour is
stumping me. Any help would be wonderful. If you think it is a bug, let
me now and I'll file one.
(select values in DB (date stamps) between Jan 1,
On Mon, 29 Aug 2005, Crystle Numan wrote:
I am fairly knowledgeable about PostgreSQL but this behaviour is
stumping me. Any help would be wonderful. If you think it is a bug, let
me now and I'll file one.
(select values in DB (date stamps) between Jan 1, 2000 and Jan 1, 2005,
no results)
a beter idea is to use -mm-dd hh:mi:ss format
2005/8/29, Martijn van Oosterhout kleptog@svana.org:
On Mon, Aug 29, 2005 at 04:48:49PM -0400, Crystle Numan wrote:
Dear all:
I am fairly knowledgeable about PostgreSQL but this behaviour is
stumping me. Any help would be wonderful. If
It looks like your value column is of a varchar(), char() or text
type. The and operators compare the ordinal value of the text
when used on text types. You'll want to use ALTER TABLE ... ALTER
COLUMN ... to change value into a numeric type (probably INT or
BIGINT), and then you'll get the