[SQL] empty data
От | Sergio Brandano |
---|---|
Тема | [SQL] empty data |
Дата | |
Msg-id | 199807131051.MAA01703@maya.wonderland.org обсуждение исходный текст |
Ответы |
Re: [SQL] empty data
|
Список | pgsql-sql |
> serbr=> CREATE TABLE foo (mtdata date); > CREATE > serbr=> \dt > > Database = serbr > +------------------+----------------------------------+----------+ > | Owner | Relation | Type | > +------------------+----------------------------------+----------+ > | serbr | foo | table | > +------------------+----------------------------------+----------+ > serbr=> INSERT INTO foo VALUES (''); > ERROR: Bad date external representation > serbr=> INSERT INTO foo VALUES ('//'); > ERROR: Bad date external representation My problem arise in a more general context, where the date may not be available at the time of data insert/update, and the data must be empty. What can I do? (I would not like to define a my own date-type...) Sergio
В списке pgsql-sql по дате отправления: