Re: A few SQL questions

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, using only a char(5)
>> type, but there's a constraint on that column that says it must adhere to
>> idrule, and idrule is defined as:
>>
>> create rule idrule as @id like "[0-9][0-9][0-9][0-9][0-9]" (ugly, I know,
>> but i didn't write it)
>>
>
> A domain will do this:
> http://www.postgresql.org/docs/8.2/interactive/sql-createdomain.html
> http://www.postgresql.org/docs/8.2/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP
> in the constraint portion of the syntax you can specify a regular expression
> id ~ '^[0-9]{5}$'
>
>
>> 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;
>>
>
> generate_series() should do what you want.
> http://www.postgresql.org/docs/8.2/interactive/functions-srf.html
>
> Regards,
>
> Richard Broersma Jr.
>
>