Re: output a single and double quote in a string

----- Original Message -----
From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Sent: Friday, March 18, 2005 3:41 PM
Subject: [NOVICE] output a single and double quote in a string

> Hi All,
>
> I am trying to create output that contains a dimension and the user would
> like
> to see single quote for feet and double quote for inches. I have not as
> yet
> stumbled on the solution.

How about

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;

>
> SELECT length_ft::text || \' ||
> length_in::text || \" AS length_dim,
> width_ft::text || \' ||
> width_in::text || \" AS width_dim
> FROM sales_order.tbl_net_production;
>
> Kind Regards,
> Keith
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>