On Jan 12, 2005, at 2:00 PM, Kieran Ashley wrote:
I'm still not entirely sure _why_ that works, but it does... so I can
go home now! ;)
You should look at section 37.2.1 in the current docs. 8.0 has a new
dollar quoting feature which makes this easier to deal with.
http://www.postgresql.org/do
bject: Re: [SQL] Problems with Quotes
Kieran Ashley wrote:
> I tried that. It starts spitting out the rest of the script to STDIN until
> it gets to the next " (which is being used to quote a table name about 100
> lines further on" at which point it throws an error, and dies.
On Wed, Jan 12, 2005 at 11:46:53AM -0700, Edmund Bacon wrote:
> Perhaps you are forgetting to double up on your quote chars?
If that's the problem then 8.0's dollar quoting will simplify
the situation:
CREATE OR REPLACE FUNCTION foo(text) RETURNS text AS $$
SELECT replace($1, '"', '');
$$ LANGUA
---
From: John DeSoi [mailto:[EMAIL PROTECTED]
Sent: 12 January 2005 18:18
To: Kieran Ashley
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Problems with Quotes
On Jan 12, 2005, at 1:08 PM, Kieran Ashley wrote:
I've tried using the replace() function to get rid of the ", but I
can't
uot;' or ''"'
seems to work.
-Original Message-
From: John DeSoi [mailto:[EMAIL PROTECTED]
Sent: 12 January 2005 18:18
To: Kieran Ashley
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Problems with Quotes
On Jan 12, 2005, at 1:08 PM, Kieran Ashley wrote:
>
On Jan 12, 2005, at 1:08 PM, Kieran Ashley wrote:
I've tried using the replace() function to get rid of the ", but I
can't figure out how to use it without throwing an error. I tried
replace(col_name, '\"', '')
and several other permutations but to no avail, do I need to use
something like an A
Hi,
I have a PL/SQL function which breaks up a comma-separated list of values
stored in one column, and uses that (along with other data) to make a new table.
My problem is that some of the incoming data is quoted e.g.
"value1, value2, value3"
Meaning that when I split on the commas, I end up
