Re: inet/cidr data types

Hi Russel,

it might be more easy and faster if you use the copy comand:

COPY targettable
    FROM 'filename' [USING] DELIMITERS 'delimiter'
    WITH NULL AS ''

delimiter depends on your data, either ',' or ';' or '\t'

Regards
Tino


--On Freitag, 8. November 2002 12:18 +0000 Russell Aspinwall
<russell.aspinwall@flomerics.co.uk> wrote:

> Hi,
>
> I need to store 2GB of accumulated data into a database. I have built
> v7.2.3 with Java, Tcl/Tk, Perl, C++ language extensions. I have written
> nawk scripts to convert csv data into the appropiate INSERT INTO
> commands, then adding the data is a simple matter of running psql -d
> <database> -f date.psql
>
> Some of the fields are of type inet or cidr , however these fields do
> not always contain a value. I need to be able to set the field to null
> in my INSERT INTO command the empty values are represented by ''.
> However during the INSERT command, the command can fail with a message
> like. I would like to be able to queries on these fields but
> automatically exclude the null values.
>
> psql:test.psql:1: ERROR:  invalid CIDR value ''
>
> Any help would be appreciated.
>
> Russell
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)