into a table
> -Original Message-
> From: [hidden email]
> [mailto:pgsql-sql-
> [hidden email]] On Behalf Of
> lmagnell
> Sent: Friday, October 19, 2012 4:25 PM
> To: [hidden email]
> Subject: [SQL] Insert strings that contain colons into a table
>
> How can
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,
