Re: How best to handle null in cast of column subquery

2014-02-13 Thread John English
On 12/02/2014 17:38, Frank Rivera wrote: How best to handle null in cast of column subquery? There are five records each with data in every column but when we run this statement below only some of the columns are returned. *If we remove the cast statement then all columns are returned. The Age

ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.

2014-02-13 Thread Derek Lewis
Hello, I'm struggling to write upgrade and rollback SQL for a CHAR(16) FOR BIT DATA column. It's currently 16-bytes long, but I'd like to migrate it to a BLOB since I'll need to put more data in it soon. I'm using liquibase for the migration. Upgrading is fine, I add a new column, and do