Quoting Daryl Richter <[EMAIL PROTECTED]>:
[EMAIL PROTECTED] wrote:
> Quoting Daryl Richter <[EMAIL PROTECTED]>:
>> It's hard to say without knowing more precisely what you are trying to
>> model, but I think this push you in the right direction:
>>
> Okay, but references between (output/input) a
Hi SQLers,
in 8.0, joining 2 tables:
CREATE TABLE network (
id cidr PRIMARY KEY , -- 'PK, ,IPv4/6 Network address'
...
)
CREATE TABLE address (
id inet PRIMARY KEY , -- 'PK of IPv4/6 host address'
...
)
as:
SELECT COUNT(*) FROM address A
WHERE NOT EXISTS (
SELECT A.id FROM ne
Hi,
I should to write a function which has one text parameter ;
throught this parameter a query will be passed to the function;
in the function the query will be executed and the result put in the
record type;
the problem is:
how can I to get the columns value if the query is not defined a prior
[EMAIL PROTECTED] wrote:
> Quoting Daryl Richter <[EMAIL PROTECTED]>:
>
>> It's hard to say without knowing more precisely what you are trying to
>> model, but I think this push you in the right direction:
>>
[snipped old schema]
>
> Okay, but references between (output/input) and ACTIVITY table
Hello there
I've a problem. I can't find some information about nested tables in
PostgreSQL. Is this Features possible in pgsql or not?
* When yes, how i can use and create nested tables with pgsql?
* When no, which alternative are there (for same problem definition)?
Thank you for help.
Gree