Search Postgresql Archives

Re: A few SQL questions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux