CAST SQL pane
| От | Ódor Balázs Péter |
|---|---|
| Тема | CAST SQL pane |
| Дата | |
| Msg-id | 51A09B48.6060801@obiserver.hu обсуждение исходный текст |
| Ответы |
Re: CAST SQL pane
|
| Список | pgadmin-support |
Hi, Im using pgAdmin 1.16.1 on Windows 7 64bit, connected to an PostgreSQL 9.2.4. Im navigate in Object browser to database -> "Casts" -> "text->http.user_agent", and the "SQL pane" is: -- Cast: "text->http.user_agent" -- DROP CAST (text AS http.http.user_agent) CREATE CAST (text AS http.http.user_agent) WITH FUNCTION http.text_user_agent(text); Errors: 1. The full name of my custom type is: http.user_agent 2. missing final ";" in "DROP CAST" command. So, the correct SQL pane's value is: -- Cast: "text->http.user_agent" -- DROP CAST (text AS http.user_agent); CREATE CAST (text AS http.user_agent) WITH FUNCTION http.text_user_agent(text); Regards, Balazs
В списке pgadmin-support по дате отправления: