Re: proposal casting from XML[] to int[], numeric[], text[]

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: proposal casting from XML[] to int[], numeric[], text[]
Дата
Msg-id 162867790711120145i19c52049pea9a6ac25a2d352@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal casting from XML[] to int[], numeric[], text[]  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
> >
> > You're right, that's my mistake, sorry. So, having casting rules seems
> > to be the only option..
> >
>
>
> We can already cast as text[], and so we can do this:
>
> andrew=# select
> xpath('//foo/text()','<a><foo>1</foo><foo>2</foo></a>')::text[]::int[];
>  xpath
> -------
>  {1,2}
> (1 row)
>
>
> So why do we desperately need anything extra at all?
>

I was blind. My problem was with function index over xml array, that
isn't indexable.

I didn't find multiple casting.

Regards
Pavel

> cheers
>
> andrew
>


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: How to keep a table in memory?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit