Skip site navigation (1) Skip section navigation (2)

Re: output a single and double quote in a string

From: George Weaver <gweaver(at)shaw(dot)ca>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: KeithW(at)narrowpathinc(dot)com,PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: output a single and double quote in a string
Date: 2005-03-19 04:15:26
Message-ID: 000f01c52c3a$4f824570$6400a8c0@Dell4500 (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Michael,

You're right, I did drop the || operator at the end of the first line when 
copying Keith's code.  I also made the assumption (perhaps mistakenly) that 
Keith was using this in plpgsql, hence the escaped '.

Regards,
George

----- Original Message ----- 
From: "Michael Fuhr" <mike(at)fuhr(dot)org>
To: "George Weaver" <gweaver(at)shaw(dot)ca>
Cc: <KeithW(at)narrowpathinc(dot)com>; "PostgreSQL Novice" 
<pgsql-novice(at)postgresql(dot)org>
Sent: Friday, March 18, 2005 8:56 PM
Subject: Re: [NOVICE] output a single and double quote in a string


> On Fri, Mar 18, 2005 at 05:13:32PM -0600, George Weaver wrote:
>>
>> SELECT length_ft::text || chr(39)
>>        length_in::text || \' " \' AS length_dim,
>>        width_ft::text || chr(39) ||
>>        width_in::text || \' " \' AS width_dim
>>   FROM sales_order.tbl_net_production;
>
> Not quite -- that produces errors because of a missing || operator
> and single quotes that shouldn't be escaped (at least not in a
> standalone query).  Perhaps you meant this:
>
> SELECT length_ft::text || chr(39) ||
>       length_in::text || '"' AS length_dim,
>       width_ft::text || chr(39) ||
>       width_in::text || '"' AS width_dim
>  FROM sales_order.tbl_net_production;
>
> Other examples:
>
> SELECT '\'' AS single_quote, '"' AS double_quote;
> SELECT '''' AS single_quote, '"' AS double_quote;
> SELECT $$'$$ AS single_quote, $$"$$ AS double_quote;  -- 8.0 and later
>
> See "String Constants" in the "SQL Syntax" chapter of the documentation:
>
> http://www.postgresql.org/docs/8.0/interactive/sql-syntax.html#SQL-SYNTAX-CONSTANTS
>
> -- 
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
> 



In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2005-03-19 04:38:38
Subject: Re: Question on simulating Enum Data type
Previous:From: Michael FuhrDate: 2005-03-19 02:56:41
Subject: Re: output a single and double quote in a string

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group