Insert strings that contain colons into a table

Поиск
Список
Период
Сортировка
От lmagnell
Тема Insert strings that contain colons into a table
Дата
Msg-id 1350678292407-5729104.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Insert strings that contain colons into a table  ("David Johnston" <polobo@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Re: Trigger triggered from a foreign key
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: Insert strings that contain colons into a table