[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 по дате отправления: