, January 05, 2012 7:56 AM
To: PostgreSQL (SQL)
Subject: [SQL] When To Use Quotes
I'm trying to understand when in SELECT statements should and should I not use
single quotes to filter my results. For example:
SELECT * FROM people
WHERE fname = 'James';
or
SELECT * FROM price
WHERE
I'm trying to understand when in SELECT statements should and should I
not use single quotes to filter my results. For example:
SELECT * FROM people
WHERE fname = 'James';
or
SELECT * FROM price
WHERE msrb
BETWEEN 50 AND 100;
Now is it correct to say that in PostgreSQL or ANSI SQL in general I