On Tue, Jul 7, 2009 at 10:17 AM, Simon Riggs<si...@2ndquadrant.com> wrote: > > > Integer works best since it converts easily to boolean > > mybool smallint check (mybool in (0, 1)) > > You can use "char" also, but the syntax is less clear.
Hm, I was going to suggest using boolean in postgres and making a "boolean" domain in Oracle for char(1) and then write all sql to compare with = 'f' and = 't'. It's annoying you can't use "WHERE foo_flag" and have to write "WHERE foo_flag = 't'" but otherwise that would give you the same sql in both flavours. -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
