From: | Christian Stalp <christian(dot)stalp(at)gmx(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Problem while inserting a varchar |
Date: | 2008-02-17 19:54:49 |
Message-ID: | 47B89109.4040301@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello, thank you Tom Lane, thank you Michael Glaesemann,
Tom Lane wrote:
>
>
> 1. Explicitly say you want the default for the first column:
>
> INSERT INTO RETRY VALUES ( DEFAULT, '0:40:f4:d3:0:0', ... );
>
That seems to work. I allready omited rid, I think this was the problem.
Now I write (trough my program): INSERT INTO RETRY VALUES ( DEFAULT,
'0:40:f4:d3:0:0','0:40:f4:d3:0:0',1, 2008-02-17,20:34:00 );
But now I get an syntax-error at character 87 »:«. I think that has
nothing to do with my first problem.
The datatype here is time. Does the ":" has a special meaning here?
> 2. Use a column name list, and omit "rid" from it:
>
> INSERT INTO RETRY (source_macaddress, destination_macaddress, ...)
> VALUES ( '0:40:f4:d3:0:0', ... );
>
> 3. Put the serial column last, so that you can just omit it without
> saying anything. (This last is not strictly according to the letter of
> the SQL spec, I think, but PG allows it and so do some other databases.)
>
> BTW, why don't you use the "macaddr" data type for those MAC address
> columns? Then you'd get some error checking ...
>
Really? I did not find anything in the documentation about it. That
would be very appropriate.
Gruss Christian
From | Date | Subject | |
---|---|---|---|
Next Message | Brandon Kane | 2008-02-17 23:05:13 | Query Planner Issue - View and regexp_replace? |
Previous Message | Tom Lane | 2008-02-17 19:22:50 | Re: Problem while inserting a varchar |