-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Monday 15 September 2003 09:09, Christopher Kings-Lynne wrote:
> Hi,
>
> Are we going to address the fact that you can't enter 3 digit years without
> a leading 0?
>
> australia=# select '111-01-01'::date;
> ERROR: Bad date external representation '111-01-01'
>
> australia=# select '0111-01-01'::date;
> date
> ------------
> 0111-01-01
> (1 row)
>
> I can't see any reason why we shouldn't allow it???
Works here(7.4beta2):
andreak=# select '111-01-01'::date; date
- ------------0111-01-01
(1 row)
andreak=# select version(); version
- -----------------------------------------------------------------------------------------------------------PostgreSQL
7.4beta2on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
(Mandrake Linux 9.1 3.2.2-3mdk)
(1 row)
- --
Andreas Joseph Krogh <andreak@officenet.no>
Managing Director, Senior Software Developer
OfficeNet AS
- - There are 10 kinds of people in the world, those that can do binary arithmetic and those that can't.
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/ZW3mUopImDh2gfQRAlNIAKCF62WbRGJSP1QwM+qJzUjBiSM3gQCbBM4N
SmXAdFqCK+Wf6EVTw/W9buo=
=+Hrc
-----END PGP SIGNATURE-----