Re: Why are clobs always "0"

Adrian Klaver <[email protected]>
Newsgroups gmane.comp.db.postgresql.general
Message-ID <[email protected]>
On 12/1/19 9:31 AM, Arnie Morein wrote:
> I have tested the most recent driver in three different SQL IDEs, and 
> now with an application I'm writing that uses JDBC metadata, the comment 
> on a field definition also isn't available as a string value.
> 
> The only thing I ever see regarding data type "text" field values are 
> either a 0 or a 1; neither of which applies.
> 
> So why is this happening, even from the JDBC metadata results as well?


You are going to have to be more specific:

1) You refer to clob, but the clob datatype is not supported:
https://www.postgresql.org/docs/11/unsupported-features-sql-standard.html
So what are you referring to?

2) Comment on field definition is what exactly?

3) How are you fetching the metadata?


-- 
Adrian Klaver
[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.