Re: Posgres Adding braces at beginning and end of text (html) content - Mailing list pgsql-general

From nighthawk
Subject Re: Posgres Adding braces at beginning and end of text (html) content
Date
Msg-id 7832fd560904241539v5f96898bwc84b52b208d401d0@mail.gmail.com
Whole thread Raw
In response to Re: Posgres Adding braces at beginning and end of text (html) content  (linnewbie <linnewbie@gmail.com>)
List pgsql-general
On Thu, Apr 2, 2009 at 3:33 PM, linnewbie <linnewbie@gmail.com> wrote:

> set page_content [lindex [ dbh $sql ] 0]

I have never heard of tclodbc, but I believe you are putting the first
row into your variable, which is why it shows with curly braces. The
problem should be more obvious when you try to fetch more than one
column from the table. Try this:

set page_content [lindex [lindex [ dbh $sql ] 0] 0]

That should solve your problem.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can't use "any" with SQL functions
Next
From: Miguel Miranda
Date:
Subject: delete duplicates takes too long