Re: [SQL] When To Use Quotes

2012-01-05 Thread Plugge, Joe R.
, 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

[SQL] When To Use Quotes

2012-01-05 Thread Carlos Mennens
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