From: | Sergio Brandano <serbr(at)tin(dot)it> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Cc: | serbr(at)tin(dot)it |
Subject: | [SQL] empty data |
Date: | 1998-07-13 10:51:04 |
Message-ID: | 199807131051.MAA01703@maya.wonderland.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Stuart Rison | 1998-07-13 16:30:16 | Re: [SQL] empty data |
Previous Message | Herouth Maoz | 1998-07-12 11:03:56 | RE: [SQL] Single vs. multiple indexes |