Re: [GENERAL] COPY FROM and multiple null strings

2007-03-06 Thread Angva
On Mar 3, 2:12 pm, [EMAIL PROTECTED] ("Joshua D. Drake") wrote: > There are two immediate ways I can think of to handle this. > > 1. Write a parser in before insertion > > 2. copy everything into text columns and clean from there. > > Joshua D. Drake That's what I feared. :) Thanks, Joshua. Mark

Re: [GENERAL] COPY FROM and multiple null strings

2007-03-03 Thread Joshua D. Drake
Angva wrote: > Hi, > > I've run into a little snag in my data loads, and I come seeking > advice before I resort to an ugly workaround... > > I have a function which runs COPY FROM several times. My problem is > that my data provider uses symbols to represent nulls - there is a > different symbol

[GENERAL] COPY FROM and multiple null strings

2007-03-03 Thread Angva
Hi, I've run into a little snag in my data loads, and I come seeking advice before I resort to an ugly workaround... I have a function which runs COPY FROM several times. My problem is that my data provider uses symbols to represent nulls - there is a different symbol for each different data type