using composite types in insert/update
От | Merlin Moncure |
---|---|
Тема | using composite types in insert/update |
Дата | |
Msg-id | b42b73150901280903kee75173nafd9393fb24f3a17@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: using composite types in insert/update
Re: using composite types in insert/update |
Список | pgsql-hackers |
IMO, composite types on insert/update should work as they do on select: SELECT foo FROM foo; -- works, returning type foo INSERT INTO foo VALUES '(something)'::foo -- fails, but we have a workaround: INSERT INTO foo SELECT ('(something)'::foo).* -- expands foo into foo columns however no such workaround exists for update. ideally, UPDATE foo SET foo = foo; would be valid. Aside from fixing a surprising behavior, it would greatly aid in writing triggers that do things like ship updates over dblink _much_ easier (in fact...the dblink_build_xxx family would become obsolete). e.g. perform dblink.dblink('UPDATE foo SET foo = \'' || new || '\'::foo); I call the existing behavior of insert/update of composite types broken to the point of almost being a bug. Fixing the above to work would close the loop on a broad new set of things you can do with composite types. merlin
В списке pgsql-hackers по дате отправления: