Insert strings that contain colons into a table - Mailing list pgsql-sql

From lmagnell
Subject Insert strings that contain colons into a table
Date
Msg-id 1350678292407-5729104.post@n5.nabble.com
Whole thread Raw
Responses Re: Insert strings that contain colons into a table
List pgsql-sql
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.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.



pgsql-sql by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Trigger triggered from a foreign key
Next
From: "David Johnston"
Date:
Subject: Re: Insert strings that contain colons into a table