From: lmagnell <lmagnell@egenera.com>
To: pgsql-sql@postgresql.org
Subject: Insert strings that contain colons into a table
Date: Fri, 19 Oct 2012 13:24:52 -0700 (PDT)
Message-ID: <1350678292407-5729104.post@n5.nabble.com> (raw)
How can I insert multiple strings into a table where the strings contain
colons.
This case fails:
INSERT INTO wwn (wwn_start,wwn_end) VALUES
('50:06:0B:00:00:C2:86:80','50:06:0B:00:00:C2:86:83');
ERROR: array value must start with "{" or dimension information at
character 71
LINE 1: ..._start,wwn_end) VALUES ('50:06:0B:00:00:C2:86:80','50:06:0B:...
But this case passes:
INSERT INTO wwn (wwn_start) VALUES ('50:06:0B:00:00:C2:86:80');
Thank you,
Lance
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Insert-strings-that-contain-colons-into-a-table-tp5729104.ht...
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lmagnell@egenera.com
Subject: Re: Insert strings that contain colons into a table
In-Reply-To: <1350678292407-5729104.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox