| From: | "Massa, Harald Armin" <chef(at)ghum(dot)de> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | Sam Mason <sam(at)samason(dot)me(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: creating array of integer[] out of query - how? |
| Date: | 2009-09-02 14:46:04 |
| Message-ID: | e3e180dc0909020746i61a423dfh7d97c1c391f51b4e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>nope...it's an array of composite types, each type with one field, and
>array of two ints. this is waht you wanted? what are you trying to do
>exactly?
yeah, that is quite what I want, just was "surprised" by the way psql
displayed the result. What I am doing:
I have a table:
key1 key2 key3 infofield
and need/want to transform it into a new dataset with:
key1, array([key3, infofield])
where key2=:externvalue
using that new type from sam I can do that now.
Many thanks!
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-09-02 14:48:07 | Re: how to use multiple schema's |
| Previous Message | Tom Lane | 2009-09-02 14:41:56 | Re: Ungooglable error message when running initdb: Symbol not found: _check_encoding_conversion_args |