On Mon, 12 Apr 1999, José Soares wrote:
> $ cal 9 1752
The cal program has special hacks for that case. The date system doesn't
know about the Gregorian Reform of dates.
Taral
with the following message:
make -C utils all
make[1]: Entering directory `/user6/home/humphrey/pgsql/src/utils'
gcc -I../include -I../backend-Wall -Wmissing-prototypes -c version.c
-o ve
rsion.o
In file included from ../include/postgres.h:42,
from version.c:30:
../include/
Hi!
On Mon, 12 Apr 1999, Mike Barnes wrote:
> Hiho ... I'd really like to know if anyone has any good suggestions for
> performing case insensitive searches on data in a 6.3 server using Perl. If
> there's some really obvious solution I'm missing, please club me over the
> head with it.
Make
Hiho ... I'd really like to know if anyone has any good suggestions for
performing case insensitive searches on data in a 6.3 server using Perl. If
there's some really obvious solution I'm missing, please club me over the
head with it.
And I hate to barge into a mailing list and make complaints,
Because most of my own code is Astronomical based, any of my time code
treats the skipped days in 1582 as invalid.
However, I think we should be careful with postgres, as anyone who is
storing dates for historical purposes, may be recording the dates for a
region who didn't change on that date (i
Hi all,
I have a question about dates.
The Gregorian reform of calendar skiped 10 days on Oct, 1582.
This reform was accepted by Great Britain and Dominions (including what
is now the USA)
only in 1752.
This is way we have Sep, 1752 like this:
$ cal 9 1752
September 1752
S M Tu W Th F S
Hi all,
Seems that PostgreSQL checks for leap day only before 1902.
prova=> select date '0001-02-29';
ERROR: date_in: day must be limited to values 1 through 28 in
'0001-02-29'
prova=> select date '1701-02-29';
ERROR: date_in: day must be limited to values 1 through 28 in
'1701-02-29'
prova=
