I have a web site devoted to quest guides for World of Warcraft
players. There is a view that gets all the data needed for the quest
details page from several tables. The view currently looks like this
(joins indicating non-null columns and left joins indicating nullable
columns):
SELECT q.id, q.
mp;
name | pay_by_quarter |schedule
--+---+---------
Bill | {1,1,1,1} | {meeting,lunch}
Ged | {1,1,11000,11000} | {training,presentation,clients}
(2 rows)
ggw_dev=> select id, name, start_id, start_name from get_
gn (=)." -- 8.10.6. Array Input and Output Syntax.
Sorry to have been such a noob, I'll go and do what it says.
Cheers,
Ged.
On 08/02/07, Ged <[EMAIL PROTECTED]> wrote:
I was on here a couple of days ago with problems getting relational
data *into* some array variables (now
Checking out a bug in my code I find in my table definition:
CREATE TABLE publications
(
...
name character varying(60) NOT NULL,
...
);
while in the function I use to populate the web page, which
amalgamates info from several sources, I have:
CREATE TYPE npc_page_details_type AS
(
