Fw: Empty date
От | Szmutku Zoltán |
---|---|
Тема | Fw: Empty date |
Дата | |
Msg-id | 000c01c535b7$575ff180$4a00000a@zoli обсуждение исходный текст |
Список | pgsql-general |
Hi , Thanks :-(( My english knowledge is big handicap for exact explanation......, but For example : I have a table, that store a production progression . All progression schema is predefined respectively for all different product . Example: Record Step Name Date (default = null) 1. Order 2005.01.10 2. Order confirmation 2005.01.11 3. Cutting 2005.01.12 4. Painting . 5. Burning .NULL. When starting a next step , then the date field change to empty ( from null ). The operator see the progression status in the screen. The client program display empty value as 'in the pipeline' and display null values as ' remaining steps' . This is an example, but I use this way often (one field, in field a standard or two or three special values - more explanation ) . In this way I can display a plus information without a plus field. Hmmm..... My own stupidity..., but no problem ere now. Thanks again : Zoltan > ----- Original Message ----- > From: "Richard Huxton" <dev@archonet.com> > To: "Szmutku Zolt�n" <szmutku.zoltan@betet-kft.hu> > Sent: Wednesday, March 30, 2005 1:01 PM > Subject: Re: [GENERAL] Empty date > > > Szmutku Zolt�n wrote: > > Hi, > > > > Valid or invalid ... indifferent . > > MySql can store ' . . ' or '0000.00.00' values to date field. > > Formerly I use Mysql , and now change to Postgres (single reason : the > > faster, record level transactions in the Postgre ) . > > My client classes (VFP 6) use empty date values and NULL values for > > different signify. > > If the Postgre not handling the empty date , then more complicated rewrite > > my older classes to Postgre for me. > > If you don't want to store dates, you could always use a text-field. > > Can I ask what the different meanings are for null vs "empty" date fields? > > -- > Richard Huxton > Archonet Ltd > > >
В списке pgsql-general по дате отправления: