On Tue, 1 May 2007, Dann Corbit wrote:
For postal addressing, this is a really good reference site:
http://www.columbia.edu/kermit/postal.html
Thank you. Frank did/does an outstanding job with Kermit, and that's a
very useful language for serial communications among data collecting devices
a
For postal addressing, this is a really good reference site:
http://www.columbia.edu/kermit/postal.html
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Rich Shepard
> Sent: Tuesday, May 01, 2007 10:42 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] CHECK() Constraint on Column Using Lookup Table
>
>
On May 1, 2007, at 12:41 , Rich Shepard wrote:
I've seen the syntax for using a lookup table in a CHECK()
constraint, but
I cannot find a reference to it. It's not in Section 5.3.1 of the
8.2 docs.
I'm not sure I follow. Generally if one has a column the value of
which belongs to a lim
On Tue, 1 May 2007, Joshua D. Drake wrote:
You could use a function, or a foreign key.
Josh,
The foreign key approach will do nicely.
Thanks,
Rich
--
Richard B. Shepard, Ph.D. |The Environmental Permitting
Applied Ecosystem Services, Inc.| Accelerator(T
am Tue, dem 01.05.2007, um 10:41:44 -0700 mailte Rich Shepard folgendes:
> I've seen the syntax for using a lookup table in a CHECK() constraint, but
> I cannot find a reference to it. It's not in Section 5.3.1 of the 8.2 docs.
>
> Specifically, I want to reference a table of ISO 2-letter cod
--- Rich Shepard <[EMAIL PROTECTED]> wrote:
>I've seen the syntax for using a lookup table in a CHECK() constraint, but
> I cannot find a reference to it. It's not in Section 5.3.1 of the 8.2 docs.
>
>Specifically, I want to reference a table of ISO 2-letter codes for US
> states and Can
Rich Shepard wrote:
I've seen the syntax for using a lookup table in a CHECK() constraint,
but
I cannot find a reference to it. It's not in Section 5.3.1 of the 8.2 docs.
Specifically, I want to reference a table of ISO 2-letter codes for US
states and Canadian provinces/territories in a ta
I've seen the syntax for using a lookup table in a CHECK() constraint, but
I cannot find a reference to it. It's not in Section 5.3.1 of the 8.2 docs.
Specifically, I want to reference a table of ISO 2-letter codes for US
states and Canadian provinces/territories in a table with name and addr
