Hannu Krosing <[EMAIL PROTECTED]> writes:
> On Sat, 2008-08-23 at 08:21 +0200, Pavel Stehule wrote:
>> record or hash table - it's implementation - second step. We have to
>> find syntax and semantic now.
> Why not just use some standard record syntax, like
> SELECT(value::type name, ...)
Yeah, that's one way. It also strikes me that hstore itself provides a
usable solution to this problem, though only for simple-string values.
That is, you could do something like
create function myfunc(hstore) returns ...
select myfunc('tag1' => '42' || 'tag2' => 'foobar' || ...);
Or, with the new variadic function support,
create function myfunc(variadic hstore[]) returns ...
select myfunc('tag1' => '42', 'tag2' => 'foobar', ...);
which is just a couple of quote marks away from the syntax Pavel
wants.
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
