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
assimilatethe 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@postgresql.org)
>


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