On Thu, 02 Jan 2003 17:19:52 -0600, "Brian Walker"
<[EMAIL PROTECTED]> wrote:
>create table test1 (name varchar(64),num1 int,num2 int);
>create unique index idx1 on test1(name,num1);
>insert into idx1 values ('row3',null,22);
>insert into idx1 values ('row3',null,23);
>
>This is allowed to happen.
Regards .
I hope someone can help me in this
query.
Have a field in a table that needs to
check if another table has the value that is being inserted.
Ex:
table A
- id int constraint
pkey_id primary key,
table B
- id int constraint
fkey_A_B referenc
On Fri, 3 Jan 2003, Pedro Igor wrote:
> Regards .
>
> I hope someone can help me in this query.
> Have a field in a table that needs to check if another table has the value that is
>being inserted.
> Ex:
> table A
> - id int constraint pkey_id primary key,
>
>
> table B
>
Through preliminary examination, it appears stored procedures using pl/pgsql
in PostgreSQL 7.3 are interpreted, rather than compiled?
When we insert a stored function into PostgreSQL, the syntax check is not done
until execution, and only on the branch/path of execution, not on the entire
funct
Thanks to previous help I am using:
$sql = "SELECT " .
"ic.relname AS index_name, " .
"bc.relname AS tab_name, " .
"ta.attname AS column_name, " .
"i.indisunique AS unique_key, " .
"i.indisprimary AS primary_key " .
"FROM " .
"pg_class bc, " .
