Re: Turning column into row

On Wed, 22 May 2002, Tille, Andreas wrote:

<snip/>
> I see no reason why this should not work - but I even see no real
> advantage to store a bitfield instead of just the concatenated string
> in a temporary table which is removed afterwards anyway.
>
> Thanks for the further hint
>
> Andreas.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

For what it's worth the string contat option in MY opinion is a quite a
clumsy solution. The advantage of using the bitfield approach is one of
compactness, elegance and speed.

Operations on integers are inherently faster than operations on strings,
regardless of the language used. I think you should give this option some
more consideration. Having said that, you are the one developing the
application and not me.

:-)

--
Regards,

Wm. G. Urquhart
Custom Software Solutions
http://www.wurquhart.co.uk