[SQL] empty data

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

Responses

Browse pgsql-sql by date

  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