[SQL] empty data - Mailing list pgsql-sql

From Sergio Brandano
Subject [SQL] empty data
Date
Msg-id 199807131051.MAA01703@maya.wonderland.org
Whole thread Raw
Responses Re: [SQL] empty data  (Guido Piazzi <gpiazzi@nemo.it>)
List 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 by date:

Previous
From: Herouth Maoz
Date:
Subject: RE: [SQL] Single vs. multiple indexes
Next
From: "Fehér Csabáné"
Date:
Subject: medical database -- help needed