Postgres Pro
Downloads
Home   >   mailing lists

Nested composite types again - Mailing list pgsql-novice

From Michael Kolomeitsev
Subject Nested composite types again
Date
Msg-id CAABbzO3RJb_4sobpkNy3hE2JZXZuWAGwy6Fr_bqvdM+0C5KJbQ@mail.gmail.com
Whole thread Raw
Responses Re: Nested composite types again  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
List pgsql-novice
Tree view
Hi,

but it didn't help.

CREATE TABLE nodes (
  id SERIAL NOT NULL PRIMARY KEY,
  name TEXT NOT NULL
);

CREATE TYPE pathId AS (
  id INTEGER,
  node nodes
);

CREATE OR REPLACE FUNCTION test_AEN7304() RETURNS void AS $$
DECLARE
  r pathId;
  n nodes;
BEGIN
  n.name := 'abc';
  r.id := 1;
  r.node := n; -- All is ok
--  r.node.name := 'def'; -- << Error here
--  (r).node.name := 'def'; -- << and here
  ((r).node).name := 'def'; -- << and here
END;
$$ LANGUAGE 'plpgsql';

And I can't even make 'n' as ALIAS FOR r.node (to simulate C-like pointer).

What is the right syntax?
Thanks

pgsql-novice by date:

Previous
From: Gavan Schneider
Date:
Subject: Re: Curiosity: what is PostgreSQL doing with data when "nothing" is happening?
Next
From: Vibhor Kumar
Date:
Subject: Re: Nested composite types again