Re: Syntax Error?

On Thu, 3 Feb 2011, Jeff Davis wrote:

> Is it possible that the values themselves have the quotation marks?

Jeff,

Yes, they do because they're strings:

\N \N 'GW-24' 1993-10-08 'Arsenic' 0.008 \N \N

> Maybe try:
> select * from monitor where location = '''GW-24''';

Yes, this works.

Shouldn't the strings be delimited by single quotes in the .csv file from
which the table is created?

There must be someting I've done incorrectly because all the char columns
have single quotes in the dumped file, but I cannot use single quotes to
select them. I should fix this while I have only 31K rows in the table!

Thanks,

Rich