single quotes in a select statement

From: "Joseph" <lters(at)mrtc(dot)com>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: single quotes in a select statement
Date: 2001-05-11 15:27:16
Message-ID: JBEPLLKEDKIHJBCHDDOGCEIDCCAA.lters@mrtc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-11 15:30:21 Re: Drop view
Previous Message Tom Lane 2001-05-11 15:13:55 Re: Problems on inserting with DBD::Pg