Re: [sqlalchemy] Casting an overlap filter as an array

2013-05-14 Thread Glenn Yonemitsu
Thanks for the reply. Your example made me realize my model did not also use VARCHAR. Changing the model column type to match the casting type made this work. On Friday, May 10, 2013 3:57:36 PM UTC-4, Audrius Kažukauskas wrote: On Mon, 2013-05-06 at 11:04:57 -0700, Glenn Yonemitsu wrote:

Re: [sqlalchemy] Casting an overlap filter as an array

2013-05-10 Thread Audrius Kažukauskas
On Mon, 2013-05-06 at 11:04:57 -0700, Glenn Yonemitsu wrote: In Postgresql I have a CMS entry model with a tag column varchar(20)[]. I want to do a query so a row with any of the tags will be returned. I know overlap is the method to use but I can't get the casting done correctly. Right

[sqlalchemy] Casting an overlap filter as an array

2013-05-06 Thread Glenn Yonemitsu
Hi, all. In Postgresql I have a CMS entry model with a tag column varchar(20)[]. I want to do a query so a row with any of the tags will be returned. I know overlap is the method to use but I can't get the casting done correctly. Right now I am trying (and a lot of searching revealed similar