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> |
Subject: | Re: output a single and double quote in a string |
Date: | 2005-03-19 02:56:41 |
Message-ID: | 20050319025641.GA89923@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | George Weaver | 2005-03-19 04:15:26 | Re: output a single and double quote in a string |
Previous Message | Sean Davis | 2005-03-19 01:29:41 | Re: Best way to input data |