Skip site navigation (1) Skip section navigation (2)

using composite types in insert/update

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: using composite types in insert/update
Date: 2009-01-28 17:03:56
Message-ID: (view raw or whole thread)
Lists: 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).

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.



pgsql-hackers by date

Next:From: Tom LaneDate: 2009-01-28 17:35:42
Subject: Re: 8.4 release planning
Previous:From: Tom LaneDate: 2009-01-28 17:00:15
Subject: Re: pg_upgrade project status

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group