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.
[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 tables is 1
to
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
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
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) and ACTIVITY
