On 2010-02-17 10:01, Alexander Barkov wrote:
Hi Sjoerd,
I noticed OCTET_LENGTH(blob_column) does not work.
According to the SQL standard, OCTET_LENGTH() is for both both character strings and binary strings.
I found that this workaround:
SELECT LENGTH(CAST(intag as TEXT))
seems to return what I need.
But it would be nice to make OCTET_LENGTH() work in the future :)
Do you have a feature request database? I can file a new request.
Yes: https://sourceforge.net/tracker/?group_id=56967&atid=482471
Thanks.
------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Sjoerd Mullender