I was on here a couple of days ago with problems getting relational
data *into* some array variables (now solved thank you), but now I'm
here with problems getting data *out* again.
A week or so ago I did a little test page with a little test table
pulled from some example about postgres arrays.
OK I reread the array documentation and something that didn't stand
out before now does :).
By default, the lower bound index value of an array's dimensions is
set to one. If any of an array's dimensions has a lower bound index
not equal to one, an additional decoration that indicates the actual
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,
Ged [EMAIL PROTECTED] writes:
SELECT
q.id, q.name, q.summary, q.instructions, q.experience, q.notes,
q.starts, q.ends
, q.stage, st.description
, q.series, r.name
, COALESCE('../zones/' || q.zone, '../instances/' || q.instance)
, COALESCE(z.name, i.name)
INTO
