Re: Simple query question

From: "Reshat Sabiq" <sabiq(at)purdue(dot)edu>
To: <paul(at)entropia(dot)co(dot)uk>, "'Chris Boget'" <chris(at)wild(dot)net>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Simple query question
Date: 2002-12-23 14:12:19
Message-ID: 000101c2aa8d$51cbb310$e280d380@main
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

----------------
The section called basic sql commands, double quotes seem to be
reserved for objects(relations/attributes) though are not required so
if you double quote (or not quote) a value in a where clause pgsql
will look for the corresponding object and most likely fail. Always
enclose values in single quotes.
-------

I believe Oracle requires singles for values too. That must be a
standard.

Sincerely,
r.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Devinder K Rajput 2002-12-23 17:33:45 performance question
Previous Message paul butler 2002-12-23 13:46:00 Re: Simple query question