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,

[GENERAL] A few SQL questions

2006-12-14 Thread Peter Koczan
ay to do something like this in postgres? 2. Is there any nice way to generate number sequences via select? In other words, something along the lines of: select 1 through 10 as number; number 1 2 3 4 5 6 7 8 9 10 but more syntactically correct and working. Thanks much, Peter Koczan