* Ben <[EMAIL PROTECTED]> [2004-10-06 08:23:11 -0700]:
> If I have have the table:
>
> create table foo
> (
> a int references bar(id),
> b int references baz(id)
> )
>
> ... how do I make sure one and only one of the columns a and b are
> non-null? Is it even reasonable?
ALTER TAB
* Alexander Cohen <[EMAIL PROTECTED]> [2004-10-01 14:42:07 -0400]:
> Im trying to connect locally to a database on a running postgres
> cluster. If i connect with psql, everything is fine and i can transact.
> I i try and connect in my own app, i get this error:
>
> Could not connect to server:
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2004-09-28 17:28:25 -0400]:
> . List all functions have been defined (e.g., defined through
> pg/sql) within a database
SELECT proname FROM pg_proc JOIN pg_language ON (pg_proc.prolang =
pg_language.oid) WHERE pg_language.lanname = 'plpgsql';
--
Steven K