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

Re: output a single and double quote in a string

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: George Weaver <gweaver(at)shaw(dot)ca>, 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-21 14:20:32
Message-ID: 20050321140050.M57131@narrowpathinc.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Fri, 18 Mar 2005 22:15:26 -0600, George Weaver wrote
> 
> ----- 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/
> >
> 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

George & Michael,

Thank you both for the pointers.  The query is now working and producing the
results that I needed.

Kind Regards,
Keith

In response to

pgsql-novice by date

Next:From: Celia McInnisDate: 2005-03-21 17:36:42
Subject: timestamp group by bug???
Previous:From: Michael FuhrDate: 2005-03-21 03:35:52
Subject: Re: environment variables

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