[VS2005] PGSQL Column Value Concatenation in TableAdapter Query

Hello all,

I'm working on a solution that interfaces with a PostgreSQL db, which occasionally uses the || operator to concatenate column values in a SELECT statement. Visual Studio 2005 is apparently baffled by this operator in TableAdapter queries, as it gives an error and does not generate parameters. It also likes to crash completely when I select the option to ignore the error and continue.

I have only managed to successfully create these by creating a simple query, then manually modifying the DataSet Designer file to be the desired query.

I was wondering:

A. Are there any better workarounds? I considered a Concat() stored proc, but that presents the issue of multiple parameters.

B. Does VS2008 resolve this issue? If so, I would rather update than implement a workaround.

Thanks in advance to any replies!

re: [VS2005] PGSQL Column Value Concatenation in TableAdapter Query

Hi again,

I've found a work-around, but if anyone is aware whether this issue has been resolved in VS2008, it would be much appreciated.

EDIT: Nevermind, VS 2005 has the same problem with square bracket characters, ARRAY_TO_STRING(ARRAY[col1, col2], ' ') does NOT work.

Still searching for a workaround that does not require manual editing of the DataSet designer file.