Re: [GENERAL] aggregate question

1998-10-22 Thread William D. McCoy
be cast as float8. One could retrieve the variance in a similar way. These are awkward to type, but I usually keep queries in text files that I send to psql on a command line. Of course, a nice set of statistical functions would be welcome. -- William D. McCoy Geosciences University of Massachuset

Re: [GENERAL] copy from file with null date fields

1998-06-04 Thread William D. McCoy
length > strings are not NULL. They are treated as illegal dates. I believe > "\N" is used to represent NULL in the copy in/out. > > William D. McCoy wrote: > > > I'm running Postgres 6.3.2 on a Sparc20 running Solaris 2.5.1 and I'm > > ha