----- Original Message -----
From: "Keith Worthington" <keithw@narrowpathinc.com>
To: "PostgreSQL Novice" <pgsql-novice@postgresql.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
>