Re: newbie: Column CHECK(col contains '@') ?

Apologies Josh... I'm so dumb. I overlooked the Functions and Opterators chapter (it's taking me a little time to assimilate the structure of online documentation). Thanks for your patience and explanations.

/j-p.

On Sun, 12 May 2002, Josh Berkus wrote:

> JP,
>
> > Thanks Joel... that did the trick (even better than I had asked for).
> >
> > Forgive my ignorance, but it your solution a regular expression?
>
> Actually, no. The LIKE and ILIKE operators are a regular part of SQL.
> They really only accept one "wildcard", the % in place of "anything".
>
> Postgres has a Regexp operator, "~" (the tilde) which does Unix-style
> pattern-matching.
>
> > Can anyone suggest a good source where I can read up on these
> > (regex's) in relation to postgresql?
>
> 2 Places: Functions and Operators, in the online docs.
> Any beginner's guid to PostgreSQL, such as Bruce Momjian's book or the
> Wrox Press book. (see http://techdocs.postgresql.org/ ----> book
> reviews).
>
> -Josh Berkus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

-----------------------
JUSTATEST Art Online
www.justatest.com