Ah! Fantastic.
Thank you so much. I'm still not entirely sure _why_ that works, but it
does... so I can go home now! ;)
Thanks again!
-Original Message-
From: Edmund Bacon [mailto:[EMAIL PROTECTED]
Sent: 12 January 2005 18:47
To: pgsql-sql@postgresql.org
Cc: Kieran Ashley
Su
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:
>
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
eturn_null }
return [expr $1]
'
language pltcl;
Hopefully this might help out anyone else faced with a similar problem.
Kieran
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: 11 January 2005 11:35
To: Kieran Ashley
Cc: pgsql-sql@postgresql.org
Subject: Re:
Hi,
Apologies if this is the wrong list for this question, I
hope it’s not.
I’m porting an application to PostgreSQL, and
rewriting a number of transforms used to convert incoming Excel data into a
final Postgres table schema for an application. Most of it’s gone
okay, but there’s
