single quotes in a select statement - Mailing list pgsql-general

From Joseph
Subject single quotes in a select statement
Date
Msg-id JBEPLLKEDKIHJBCHDDOGCEIDCCAA.lters@mrtc.com
Whole thread Raw
Responses Re: single quotes in a select statement  (will trillich <will@serensoft.com>)
List pgsql-general
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.

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

Thanks

respectfully,
Joseph


pgsql-general by date:

Previous
From: "Michael Ansley (UK)"
Date:
Subject: RE: Synonym
Next
From: Morten Primdahl
Date:
Subject: Re: Problems w. SERIAL