On Mon, May 31, 2010 at 7:48 AM, Jan Strube <js@xxxxxxxxx> wrote: > I accidentally encountered a feature in Postgres 8.3 that I couldn't find in > the documentation while submitting a query like > > SELECT my_table.varchar FROM my_table > > which returns a concatenated string of all field values per row. > I wonder where this is documented (and if it has something to do with > composite types). > > Can anyone please explain? I don't really know, but the result looks more like a single field formatted as "ROW-WISE" rather than CSV. The official way to get this result is: SELECT ROW( my_table.* ) FROM my_table; http://www.postgresql.org/docs/9.0/static/sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
