Re: single quotes in a select statement

On Fri, May 11, 2001 at 11:27:16AM -0400, Joseph wrote:
> Is it possible to have one field
> like the following
> 
> 'some text' || case when t='1' then '1' else '2' end
> 
> I don't know how to differentiate the different quotes.

double quotes are to "glue together" attributes that would
otherwise seem to be separate tokens:

	create table "my table here" (
		"some field" varchar(20),
		"yet another" serial,
		"the last one" float8
	);

single quotes delineate string values:

	select 'here: '
			|| "some field"
			|| ' plus also '
			|| string("yet another"/"the last one")
		from "my table here";

also note that uppercase/lowercase are significant on "quoted"
attributes, but on unquoted ones everything winds up as lowercase:

	> create table mytable ("myField" varchar(10));
	CREATE
	> insert into MYTABLE(myField)values('one');
	ERROR:  Relation 'mytable' does not have attribute 'myfield'
	> insert into MYTABLE("myField")values('one');
	INSERT 1063721 1

> Can I use double quotes or some other kind of quotes inside my case
> statement?

parentheses often work wonders. but the only quotes for strings
(that i'm aware of) are 'single quotes'.

to include a single quote inside a string, try

	'it''s maybe like this'
	'we\'re not always right'

-- 
don't visit this page. it's bad for you. take my expert word for it.
http://www.salon.com/people/col/pagl/2001/03/21/spring/index1.html

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!