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!