Insert strings that contain colons into a table

From: lmagnell <lmagnell(at)egenera(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Insert strings that contain colons into a table
Date: 2012-10-19 20:24:52
Message-ID: 1350678292407-5729104.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Johnston 2012-10-19 20:34:19 Re: Insert strings that contain colons into a table
Previous Message David Johnston 2012-10-19 18:24:41 Re: Trigger triggered from a foreign key