Re: [GENERAL] A few SQL questions

2006-12-14 Thread Peter Koczan
Perfect. Exactly what I needed. Thank you very much Richard. Peter Richard Broersma Jr wrote: 1. In sybase, each column can have the same rule applied to it. You don't have to create multiple rules for columns in different tables. For instance, let's suppose that we require 5 digit numeric ids,

Re: [GENERAL] A few SQL questions

2006-12-14 Thread Richard Broersma Jr
> 1. In sybase, each column can have the same rule applied to it. You don't > have to create multiple rules for columns in different tables. For instance, > let's suppose that we require 5 digit numeric ids, using only a char(5) > type, but there's a constraint on that column that says it must adhe

[GENERAL] A few SQL questions

2006-12-14 Thread Peter Koczan
Hi all, I have a few slightly more advanced SQL questions (which is why I'm here in the first place I suppose). I'm looking to migrate some applications and databases from Sybase to Postgres, and I have a few portability-type questions, or rather, questions on how to do the equivalent in Postgres.